How to replace blanks with 0 for a measure when sliced

[Anonymous]

Hello all

I have a requirement where I have a measure [Count of Empty Bins] and it is a measure, when this measure is sliced I am getting blanks, I just want to replace them with 0. 

I tried to do a IF condition as  - = If(ISBLANK([Count of Empty Bins]),0,[Count of Empty Bins]), and when I dragged over to report level filters, i have to select one among the if outcomes either 1 0r 0. 

[parry2k]

I'm not fully understood your question. You cannot use calculated measures on report level filters, it can be only used at visual level filter.

[Anonymous]

@parry2kyes I agree I cannot use at report level filter. I am ok with any workaround but I need to achieve the goal where I want to replace those nulls with zeros of empty bin count in the visual I shared.

[parry2k]

What happen when you drop that measure you created with if statement , not sure what that measure is called because it is not clear from your post.

[parry2k]

Try following changes to you empty count measure

Empty Bin = 
var emptyCountBin = CALCULATE(Countrows(Table1), filter(table1, Table1[Column2]="Y"))
return if(ISBLANK(emptyCountBin ), 0, emptyCountBin )

Change this statement in measure with your formula

CALCULATE(Countrows(Table1), filter(table1, Table1[Column2]="Y"))

[Anonymous]

@parry2k Thank you for your time in replying. Can you please help me understand what you mean by Table1[Column2]. The empty bin measure is calcualted as below -

Count of Empty Bins:= COUNTAX(FILTER(lagp,lagp[KZLER]="X"),lagp[Bin Number])

This count is being sliced by warehouse, storage type etc. When there is no bin number corresponding to that warehouse, Storage Type, I am getting Null values and want to replace with zero. 

[v-ljerr-msft]

Hi @Anonymous,

Have you tried the solution provided by @parry2k above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[parry2k · Accepted solution]

change your measure to following

Count of Empty Bins:= 
var myEmptyBinCount = COUNTAX(FILTER(lagp,lagp[KZLER]="X"),lagp[Bin Number])
return if(Isblank(myEmptyBinCount ), 0, myEmptyBinCount )