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

3 Replies

  • 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