Forum Discussion

SemG's avatar
SemG
Advocate I
8 years ago

If statements are evaluating wrongly

I have an IF statement in a calculated column of a calculated table that evaluates wrongly. See example below. How can this happen?  
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi SemG,

 

In your scenario, which aggregation do you set for the [Boete Totaal] in the visual? Assume it's SUM, then you need to create a measure like: 

 

Measure= IF(SUM([Boete Totaal]) =100, "100","200")

 

Best Regards,
Qiuyun Yu 

SemG's avatar
SemG
Advocate I
8 years ago

Hi Qiuyun Yu,

 

Thanks for answering. I am using calculated columns and I am adding multiple calculated columns with the + operator. I am not using aggregations.

 

Best regards,

SemG

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi SemG,

     

    I mean you can check if you have set aggregation for [Boete Totaal] in the visual like below: 

     

     

     

    If it's SUM, then please try to create a measure like mentioned in my previous post. If issue persists, please share the pbix file with us. 

     

    Best Regards,
    Qiuyun Yu