Cumulative Total of Measure based on Slicer

[rampsaladi]

Hi All,

I have a requirement where I need to show the sales that were generated in the last three days. To Solve this I created a calculated column based that will tell me when the order was created in the last 24 hours or 24-48 hours or 48-72 hours. 

I used this calculated column as a slicer and applied it on the Total Sales Measure I created. Now I have a new requirement where I have sum the data based on the user selection so when user selects 24-48 It should sum up the data from both 24 and 24-48 instead of just showing the 

Any help in this regard would be great.

[v-ljerr-msft · Accepted solution]

Hi @rampsaladi,

Have you tried the solution provided by @MFelix above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. 

Regards

[MFelix]

Hi @rampsaladi,

You should try something like this to had to your model:

Total Sales = CALCULATE( SUM(Table[Values]);Table[Range]  IN {"24"; "24-48" } )

Regards,

MFelix