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 orig...
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!




amitchandak's avatar
amitchandak
Super User
6 years ago

Try to use divide also.

 

Complaints = 

IF(ISBLANK(SUM(complaints[number_complaints])), 0 , 
(divide(
(SUM (complaints[number_complaints]) ,
SUM(production[production])),0) 
*VALUE(1000000) )

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601