Forum Discussion

maserr's avatar
maserr
Icon for Helper IV rankHelper IV
5 years ago

Differentiation between 0 and blank

Hi there,   I would need to internally differentiate when a measure is 0 or blank, depending on the result of the calculation if this makes 0 or if there is no data so it cannot make a calculation....
Need Help
maserr's avatar
maserr
Icon for Helper IV rankHelper IV
5 years ago

Dear Lian

There are two cases:

1. The measure calculates and the value obtained is 0

2. The measure is not calculating anything because there is no data, so the value is NULL

The second case is possible when the measure is referring per example to a month that does not include information. How can I differentiate these two cases?

Thanks

xwl's avatar
xwl
Icon for Advocate I rankAdvocate I
3 years ago

Hello, did you find a solution?