MS Excel DAX SWITCH Based on Row Value

Question

I haven't used DAX much but I thought this would be easier. Basically I have the value [ID] in the rows of a pivot table using the data model function, and then the values [Numerator],[Denominator], and then a calculated field called [Calc] that is simply [Numerator]/[Denominator].

I would like to create another calculated field that uses different criteria based on the [ID] value in the rows section. This is what I've tried

=SWITCH(
TRUE,
[ID]="Alpha"&&[Calc]>.75,"G"
[ID]="Alpha"&&[Calc]<=.75,"R"
)

The issue is the formula can't evaluate the value of the [ID] field in the rows section, and I'm not sure how to handle this.

Mark S. · Accepted Answer · 2025-09-09 19:23:46Z

0

I think the formula you're trying to write would be. If I'm reading this correctly you want to check that both ID = Alpha and the Calc is within the parameter you set:

=SWITCH(
TRUE(),
AND([ID]="Alpha",[Calc]>.75),"G"
AND([ID]="Alpha",[Calc]<=.75) ,"R"
)

answered Sep 9 at 19:23

Mark S.

2,8911 gold badge10 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS Excel DAX SWITCH Based on Row Value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related