Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
3 years ago
Solved

Replace "Blank" with text

Hello

I have a visual with a filter on it.

I calculates the quantity of rows having the word "false" on it.

i.E. if there are 16 rows and the column "escalation" has allways "false" as value so

the result should be 16 on the visual. If I filter for true then I would like to replace the "Blank"

with "no escalation".

Is there a possibility

Regards
Heinrich

Need Help
Tips and Tricks
Tutorial Requests
  • JoZu's avatar
    JoZu
    3 years ago

    Hi Heinrich

    I assume you are displaying the data in a matrix visual, where you have some sort of category or ID as rows. For every row you want to display either the number of escalations or "no escalation" if there were none, right? I created a measure using the following DAX code: 

    Count Measure - No Escalation if 0  = 
VAR _COUNT = COUNT('Table'[column])
RETURN
IF(_COUNT = 0; "No Escalation"; _COUNT)

     

    Does this solve your issue?

    Best regards

    Joël

2 Replies

  • JoZu's avatar
    JoZu
    Frequent Visitor
    3 years ago

    Hi Heinrich

    I assume you are displaying the data in a matrix visual, where you have some sort of category or ID as rows. For every row you want to display either the number of escalations or "no escalation" if there were none, right? I created a measure using the following DAX code: 

    Count Measure - No Escalation if 0  = 
VAR _COUNT = COUNT('Table'[column])
RETURN
IF(_COUNT = 0; "No Escalation"; _COUNT)

     

    Does this solve your issue?

    Best regards

    Joël