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!




Anonymous's avatar
Anonymous
Not applicable
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!