YTD Changes

[KriZo]

I have an issue with a YTD that keeps changing. 

I measure a delivery performance from an external warehouse. Including in the model i have a YTD. But it keeps changing. 

I wrote this formula 

Service Level YTD :=CALCULATE([SL];DATESYTD('Calendar'[Date])

But if i chose to look at the service level in January, the YTD changes off course as we are now in Mar. 

So i therefor made:

Service level YTD :=CALCULATE([SL];ALL('Calendar'[Date]);DATESYTD('Calendar'[Date]))

But the Service Level YTD still changes, so apparently it doesn't overwrite my date filter. ?

I am btw doing this in PowerPivot in an Excel workbook for now, i will eventually turn it into a PowerBi report, I just haven't gotten around to that yet 🙂

[v-yulgu-msft]

Hi @KriZo,

Have you tried this:

Service level YTD :=CALCULATE([SL];ALLSELECTED('Calendar'[Date]);DATESYTD('Calendar'[Date]))

Regards,

Yuliana Gu

[KriZo]

Hi @v-yulgu-msft

Hmm that unfortuantely does excactly the same as my measures, and returns the same values 😞