Forum Discussion
Heinrich
Post Partisan
Post PartisanReplace "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 t...
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
HeinrichPost Partisan
Post PartisanHi Joël
It did work thank you.
Regards
Heinrich