Keeping 0, removing NULL from a measure

[Evan0211]

I have a measure that does a simple calculation. I need to keep show the number if the number is greater than or equal to 0, and if there is a null result, not show the null.

It seems like Measure treats 0 as NULL and I need to treat them separately. Any ideas?

[Evan0211]

This is the measure:

if(Not IsNull([Revised Date]),
Sum(Date([Revised Date]) - Today()),
sum(Date([Initial Date]) - Today()))

The result of this CAN be zero, so I need to include zero values. However, if there are no Revised or Initial dates loaded, this will return null. I need to NOT shot the null values, but if the value is zero, I DO need to show the zero value.

[BrunPierre]

Assuming the measure is the sum of sales by customer, then something like this

Sum({< Customer = {"=Sum(Sales) >= 0"} >} Sales)

[Evan0211]

I posted the measure above around the same time you posted this. I am dealing with dates, not sales. I am doing a date diff and I need to include if the diff is zero (the date is today) but I don't need to include if the date is a null (hasn't been input by the customer yet)

[Evan0211 · Accepted solution]

I figured out a work around. Instead of using sum, I used interval, which allowed me to input the measure as a dimension and then I was able to suppress null values.