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 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 ""

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

6 Replies

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

  • mede's avatar
    mede
    Resolver I
    8 years ago

    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'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.