Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Return zero when numerator is blank

Hi all

 

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

 

Complaints = 
IF(ISBLANK(SUM(complaints[number_complaints])) && SUM(production[production]) <> "", 0 , 
(
(SUM (complaints[number_complaints]) / 
SUM(production[production]))) 
*VALUE(1000000) )

 

How can I get it right?

 

Thanks!

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    o59393 

    The problem is your second condition SUM(produc

    tion[production]) <> "", <> is not equal to in DAX.
    Do you want to make this condition not equal to blank? If so, try replace with

    Not ISBLANK(SUM(production[production]))

    Or you want some thing else?

    Paul Zheng
    Don't forget to hit THUMBS UP and mark it as a solution if it helps you!




2 Replies