Forum Discussion
Solved
If function cannot check inside a column
Hi, pretty exicted for the first post in Power BI forums :smileyvery-happy: i am trying to create a measure based on an if function which should check inside a column called "Class" which has 3 ...
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
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.