Need help in fixing the TOTALS

[svinayagam1984]

Hi, I am comparing each week's Data with the prior Week to get the New, Upgrade, Downgrade, and Lost. I am able to get the correct result when I select a single date from the Slicer. But, if I select more than one date, I don't get the Total or wrong Total.

Can someone please help to fix this issue. 
My Sample File 

[Ashish_Mathur · Accepted solution]

Hi,

This measure works

Measure 2 = SUMX(VALUES('Calendar'[WeekEnd]),[New])

Use the same pattern for the others as well.

Hope this helps.