I am doing a dax to return a zero when the numerator is blank.
The problem I have is that after I create the mesaure, I get a bunch of zeros from dates that have no data.
The original state is data from 1/1/2019 to 12/12019
With the dax, I get data since 2017 up tp 2023, which is my date table.
I tried when numerator is blank and denominator is <> than zero, then return a zero. Howver I get an error
IF(ISBLANK(SUM(complaints[number_complaints])) && SUM(production[production]) <> "", 0 ,
(SUM (complaints[number_complaints]) /
How can I get it right?