Hi Sam and others

I am struggling with something that I thought would be pretty simple, but…

I have already a measure that gives me a percentage-calculation. This measure I use to compare months over months. I now want to compare it to a baseline over a given set of dates: 01012018 to 31072018. My current formula is this:

Baseline = Calculate([Wastage Percentage];

DATESBETWEEN(DimCalendarDaily[CalendardailyKey];date(2018;01;01);date(2018;12;31)))

The result I get is the same as the original measure… it seems that it is not using the datesbetween function.

I use a Calendar table which is related to the fact table from where I derive the original measure.

Any hints to how I get this one working??