Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Replacing Blank

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 becaus...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
mede
Resolver I
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Med thanks to you too.