Measure does not recognize Value of previous Day when combined with custom Rows in Matrix

[scorpi73]

Hallo everyone,

i am creating a report with a Measure that should take the Value of the previuos Day:

Previous Day = CALCULATE([Measure], DATEADD('Datum'[Date],-1,day))

Measure = CALCULATE(SUM('Table'[Value]),'Table'[Filter1]="xxxxxx",'Table'[Filter2]="yyyyyyy")

the second Measure is the actual Value for today.

in my Matrix Visual, everything is working fine:

but when i add a Date hierachie to it, it does not caculate the first day of the Month correctly. the measure doesnt pull the previous day of the last month:

Thank you!

[johnt75 · Accepted solution]

When you added the Year / Month column to the matrix that also applied a filter which is stopping any days from other months from being included. Change your measure to

Previous Day = CALCULATE([Measure], DATEADD('Datum'[Date],-1,day), REMOVEFILTERS('Datum'[Year Month))

[scorpi73]

worked like a charm!