Forum Discussion
If function cannot check inside a column
the error is gone but it does not give me the right results (it gives me all zeros!)
i re-tried the if function using measure inside the Classes table but also had to wrap it into a MAX function: and now it works perfectly
Measure = IF ( MAX ( Classes[Class] ) = "A", [Coverage A KPI], IF ( MAX ( Classes[Class] ) = "B", [Coverage B KPI], 0 ) )really appreciate your time and help
Best Regards,
Mohammad
SWITCH (true(),
Classes[Class] = "A", [Coverage A KPI],
Classes[Class] = "B", [Coverage B KPI],
Classes[Class] = "C", [Coverage C KPI],
)
the error is gone but it does not give me the right results (it gives me all zeros!)
i re-tried the if function using measure inside the Classes table but also had to wrap it into a MAX function: and now it works perfectly
Measure =
IF (
MAX ( Classes[Class] ) = "A", [Coverage A KPI],
IF ( MAX ( Classes[Class] ) = "B", [Coverage B KPI],
0 )
)really appreciate your time and help
Best Regards,
Mohammad
MAX operates on numbers, not text. For text you could use FIRSTNONBLANK or LASTNONBLANK.
mokhawaja well if it doesn't give you the correct result and it returns 0, something is wrong with the conditional statement, wouldn't it be better to try and resolve that?