Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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'?
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.
Thanks, I was wondering... this link Power BI: What is DAX? And Why you Should (or Should Not) Learn It | by ZhongTr0n | Towards Data Sci...
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...
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.
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!