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

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

    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 :) .