Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
6 years ago

Nested If Statements

Hi guys, I have 4 measures each recieving a final alpha grade (A,B,C,D).  I want to use an IF statement to essentially select specific outcomes for these measures that would match or equal a select o...
DAX
power bi
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi cdawidow 

 

You get the wrong answers because your are not grouping your 'or' statements together with paranthesis.

 

You can also try to rewrite your measure using the 'IN'-function:

IF([SALES RANK] in ("A","B") && [MARGIN FINAL] in ("A","B") && [LOYALTY] in ("A","B") && [FINALCTS] in ("C","D")

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.