Showing the zero with a measure

[Anonymous]

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...

[Anonymous]

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

[Anonymous]

Hello,

Is someone have a solution for my problem ?

Thank you very much.

[jthomson]

One fix that often works is to add +0 to the end of your measure, try that first and see if it works

[Anonymous]

This works perfectly fine ! Thank you very much 🙂