0 needs to be displayed instead of blank using measure

[madhushree]

Hi All,

I am calculating a measure something like below:

measure1=calculate(count(id),filter(table1,flag=1))

But this measure displays blank when flag is not 1, all i want is it should display 0.

Tried below measures:

1.  measure2=if(table1.flag=1,count(id),0)

2.  measure3=if(isblank([measure1]),0,count(id))

3. measure4=[measure1]+0

All the measures gives too many records due to join of tables.

 Can someone please give the solution for this.

Thanks in advance,

Madhushree

[v-jiascu-msft]

@madhushree

Hi Madhushree,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Greg_Deckler]

measure1 = VAR var1=calculate(count(id),filter(table1,flag=1))
RETURN(IF(ISBLANK(var1),0,var1))