Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Changing "(Blank)" to 0 in Visualization

Hi all,

 

Just wanted to know if there was a simple solution of making the (Blank)s into 0s when filtered down. Currently, the visualization is counting how many entries in the first column are either a Breach & Error, Change Request, Escalation or Targetted Service query. This isn't a measure though, just filtered it by "Type". Hope this makes sense & many thanks in advance.

 

Regards,

updog

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    You can create a Measure for each card visualization like:

    Measure_Escalation = 
IF(
  ISBLANK(
    CALCULATE(COUNT(Table1[type]) | FILTER(Table1|Table1[type]="Escalation"))
      )
      |0
      |CALCULATE(COUNT(Table1[type]) | FILTER(Table1|Table1[type]="Escalation"))
    )

     

    Hope it helps.

     

    Regards.

     

     

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Anonymous,

     

    You may just add zero (+ 0) to the DAX formula.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    You can create a Measure for each card visualization like:

    Measure_Escalation = 
IF(
  ISBLANK(
    CALCULATE(COUNT(Table1[type]) | FILTER(Table1|Table1[type]="Escalation"))
      )
      |0
      |CALCULATE(COUNT(Table1[type]) | FILTER(Table1|Table1[type]="Escalation"))
    )

     

    Hope it helps.

     

    Regards.