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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

maserr , Check blank with

isblank

 

example

if(isblank([Col1]),1,0)

if([Col1]=0,1,0)

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.

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