Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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'?
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.
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |