Forum Discussion

svinayagam1984's avatar
svinayagam1984
Icon for Helper I rankHelper I
5 years ago
Solved

Need help in fixing the TOTALS

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 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This measure works

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

    Use the same pattern for the others as well.

    Hope this helps.

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    This measure works

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

    Use the same pattern for the others as well.

    Hope this helps.