If statements are evaluating wrongly

[SemG]

I have an IF statement in a calculated column of a calculated table that evaluates wrongly. See example below. How can this happen?

[v-qiuyu-msft]

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]

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]

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