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.

 

thanks in advance

Need Help

5 Replies

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

      Hi,

      I know the ISBLANK() function but how internally I know the difference between a value that has calculated that the result is 0 from a result of a measure that cannot calculate anything because there is no data?

      Thanks

      • 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.