Help with conditional statement

[Anonymous]

KPI = IF([Projected Monthly Growth %]<[Progress towards CY Goal] ,0,1) .

I'm trying to compare two measures and based on the value I want to conditionally format my KPI . However Its not returning the correct results. Any Help is appreciated

[amitchandak]

@Anonymous , if the total is not correct then you need to use summarizes or values to get the correct GT

example

sumx(values(Table[Category]), IF([Projected Monthly Growth %]<[Progress towards CY Goal] ,0,1) )

why grand total is wrong

https://www.youtube.com/watch?v=ufHOOLdi_jk

[Anonymous]

The totals are fine , but the if condition is failing , my condition is if 25 < 28 , then 0 else it should be 1 but im getting 1 as the value

[v-kkf-msft]

Hi @Anonymous ,

This has to do with the return values of your two measures [Projected Monthly Growth %] and [Progress towards CY Goal]. You can put these two measures on two cards and see if they are 25 and 28.

You can also share the formulas of these measures and your sample data, which will help us quickly understand what the problem is.

Best Regards,
Winniz

[Anonymous]

Hi , My measures are returning the correct values when shown on cards or in a table . the only place where its failing is the evaluation of the IF condition .  

[v-kkf-msft]

Hi @Anonymous ,

I could not reproduce the issue, could you please share your PBIX file that doesn't contain sensitive data?

Best Regards,
Winniz