Forum Discussion

ToddMate's avatar
ToddMate
Icon for Helper II rankHelper II
7 years ago
Solved

Cumulative Total with a Slicer

Hi,
 
I have the below measure that calculates a cumulative total of my Sales (+) / Churns (-) and works well returning me the total number of active services i have:
 
SSS = CALCULATE(sum(X_Transactions[Count]),
FILTER(X_Services,X_Services[Product] = "NBN"),
X_Transactions[Event] IN {"Ons","Offs"},
ALL(D_Calendar[End of Month]))

However i would like to add a slicer to my visual to nominate the "End of Month" (from the Date table). When i select this date i would like the cumulative total up to and including that "End of Month".
 
I appreciate ALL excludes this Slicer context, but i can't find a way to do the above. Is anyone able to assist?
 
Todd
Need Help

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi ToddMate ,

     

    It's preferred to share your dummy pbix that would be easier for us to provide the valuable advices.

    Make sure you've removed the confidential info and upload the file to Onedrive/Sharepoint/Dropbox, then share the link here.

     

    Best regards,
    Dina Ye