Multiple 0 as answer

[angelikakolacz]

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

[v-yueyunzh-msft]

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