Replacing Blank

[Anonymous]

Hi, I am using couple of "single card visual".For each card visual i am using a different column, these columns have "1" and "0" as value. I am showing count of only "0"s using advanced filter because these are the failure. Now when there are no "0" in a column it returns as "(Blank)". I want to change this "(Blank)" with either "None" OR "0" OR "".

Col1   Col2   Col3
 0         1         1
 0         0         1
 0         1         1
 0         0         1

The Result i get in cards

Card 1= 4 ( count of "0"s, since i have filtered this using "is" in advance filter option.
Card 2= 2 
Card 3= (Blank) (since there are no 0s it is returning (Blank)
I want this blank to be "None" or simply "0" or ""

[Anonymous · Accepted solution]

@Anonymous,

Create the following measures in your table.

Count of 0 = CALCULATE(COUNT(Table[Col3]),Table[Col3]=0)
outputmeasure = IF([Count of 0]=BLANK(),"None",[Count of 0])



Regards,
Lydia

[Anonymous]

@Anonymous it worked. however instead of creating 2 measures i nested them together and used it as below

Col_Cnt = IF(CALCULATE(COUNT(Table[Col3]),Table[Col3]=0)=Blank(),"None",CALCULATE(COUNT(Table[Col3]),Table[Col3]=0))


Many Thanks 🙂 .

[mede]

You can just wrap your measure with an IF.

Count of zeros = CALCULATE(COUNT(Col1), Col1 = 0)

Showing blank if result is 0:

= IF(Count of zeros = 0, BLANK(), Count of zeros)

Let me know if it works.

[Anonymous]

@mede it isnt working still giving "(Blank)"

i created a measure with 
Sold To_Count = IF(Data[SOLD-TO]=0,BLANK(),Data[SOLD-TO])

then in advanced filter i used the following condition (is not 1) and also tried with (is 0).

[mede]

Hi @Anonymous, i think i might have misunderstood that you need blanks. In  any case, glad that you found a solution.

[Anonymous]

@Med thanks to you too.