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
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi maserr ,

 

The description is not very clear. Try to create such a measure:

Measure 2 = IF(ISBLANK([Measure]),"NULL",[Measure])

If it doesn't meet your requirements, please describe more about how you want to distinguish between 0 and blank.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?