Forum Discussion
Showing the zero with a measure
Hello,
I have an issue with the display of measure I have created and I don't know how to fix this.
I have a fact table with, among other facts, the number of logs (by day). This table is linked to a Box and Date dimension.
What I want to display is the number of logs during the last week by Box Number.
So I created this measure (which is actually working fine) :
Logs last week := CALCULATE(SUM('EN Documents Detail'[All logs]); 'EN Day'[Day date] >= TODAY()-7)But this measure only display the boxes with actual rows during the last week. But I need to also display the boxes with no logs during the last week (and show a zero in the column). Is it a way to do this ?
Sorry if it's a silly question but I'm a total beginer in PBI...
4 Replies
jthomsonSolution Sage
One fix that often works is to add +0 to the end of your measure, try that first and see if it works
Hello,
After "playing" with my measure I got another issue, linked to the "+0" at the end.
In my Box dimension I have an Arrival Date. When I add it to a table with the Box Number and the measure it splits every Box number with every Arrival date. However I just want to display the Arrival date of the Box number itself.
I think it's coming from the "+0", because when I use the former definition of my measure, the split disapear.
I actually don't know how I can avoid this behavior...
Here's the differences in my report :
Logs week :
CALCULATE(SUM('EN Documents Detail'[All logs]); 'EN Day'[Day date] >= TODAY()-7)Logs week 0 :
CALCULATE(SUM('EN Documents Detail'[All logs]); 'EN Day'[Day date] >= TODAY()-7)+0