Forum Discussion
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...
cdawidow , Try like
switch( true(),
[Customer Sales] in {"A","B"} && [Rank Loyalty] in {"A","B"} && [Measure Margin] in {"A","B"} && [Final cts] in {"C","D"} , "Good",
"Bad"
)
or a measure like
maxx(summarize( Table, Table[Customer Name], "Rank" ,
switch( true(),
[Customer Sales] in {"A","B"} && [Rank Loyalty] in {"A","B"} && [Measure Margin] in {"A","B"} && [Final cts] in {"C","D"} , "Good",
"Bad"
)
)