Two different measures not interacting correctly when grouped by week end

[Anonymous]

Hi PBI Comm,

I'm having issues with visualising two seperate cummulative measures that have Week end groupings as the x-axis. I suspect it is an issue with my relationship management but I can't seem to troubleshoot a method that will make it all run smoothly. I have had to force many to many relationships which I do not yet fully understand, so this may be the root of the issue. Currently when I use the "Week end" Field from the table that the measure is written from the visualisations are fine. However when I try to add both measures to the same visual only the measure from the table that the x-axis field is from shows correctly. I have attached an image of the visualisation and the relationships. 

[amitchandak · Accepted solution]

@Anonymous , need to check measures and axis column.

Ideally, You should create a date table and in that have a week column or weekend date

and you can create a measure like this for both

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4