Forum Discussion

angelikakolacz's avatar
angelikakolacz
Helper I
3 years ago

Multiple 0 as answer

Hello,

 

Can someone explain me how it's possible to have multiple 0 as a result? 

 

 

An other column, "Category", doesn't work right. Instead to give me "Factuurbedrag en openstaand saldo 0" it gives me "Uitzoeken" as answer. 

 

 

Can someone help me? Thanks

Need Help

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , angelikakolacz 

    According to your screenshot, for your first question, there is a duplicate 0,00 data, and combined with the judgment conditions of the second figure, it can be seen that the DAX does not recognize that the "0,00" is 0, you can check the following:

    (1)You can check if the column is a Number type.

    (2)You can filter for duplicate values and compare the differences that exist between them.

    (3)You can create a new column in table  to test whether "0,00" is judged to be Number 0.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly