topic Re: Make a measure display 0 instead of blank in 'card' visualization in DAX Commands and Tips

Make a measure display 0 instead of blank in 'card' visualization

Anonymous — Mon, 22 Mar 2021 17:19:54 GMT

I have my measure Revenue YearToDate as

CALCULATE( [Revenue] , DATESYTD('Date'[Date],"31/05" ))

For dates with no revenue... If I choose a 'card' visualization I get the value (blank) instead of 0, why is that? how can I change it to display 0 instead of 'blank'?

Re: Make a measure display 0 instead of blank in 'card' visualization

Anonymous — Mon, 22 Mar 2021 17:43:48 GMT

add +0 to the end of your measure

CALCULATE( [Revenue] , DATESYTD('Date'[Date],"31/05" ))+0

You could also tie it into an IF statement, for example

= VAR _RevenueYearToDate = CALCULATE( [Revenue] , DATESYTD('Date'[Date],"31/05" )) Return IF(_RevenueYearToDate= "null" , 0 ,_RevenueYearToDate)

To answer your question, it's resulting in "null" or "blank" because that is the answer. If it has nothing to calculate (because the values are blank) the answer is Blank. If it were calculating 1-1 then the answer would be 0 but "blank" - "blank" = "blank" i.e. no values can be found, therefore the result is blank.

Remember in binary "0" is a value in its own right. So if your "Revenue" column is "null" and not "0" it's treated as a null value, which is different to 0.

Re: Make a measure display 0 instead of blank in 'card' visualization

Anonymous — Mon, 22 Mar 2021 17:50:13 GMT

Thanks, I was wondering... this link Power BI: What is DAX? And Why you Should (or Should Not) Learn It | by ZhongTr0n | Towards Data Science

Says: "When displaying numerical data in a card, for example ‘revenue’, it will return ‘blank’ if you set your filters in a way there is no revenue to show. However, a more natural way to display ‘no revenue’ should be ‘0’ instead of ‘blank’. With a very simple DAX expression, you can yourself create a measure adding a ‘0’ to the formula, meaning you will never have to see ‘blank’ again."

Why the link says its very simple? it doesnt look like that...

Re: Make a measure display 0 instead of blank in 'card' visualization

Anonymous — Tue, 23 Mar 2021 11:33:07 GMT

I guess it's subjective, what one person considers simple might not be the same for another. Only the author could really answer your question.