Forum Discussion
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 sald...
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