Differentiation between 0 and blank

[maserr]

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

[amitchandak]

@maserr , Check blank with

isblank

example

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

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

[maserr]

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]

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]

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]

Hello, did you find a solution?