How to calculate cumulative totals up to the date selected in the slicer

[yoshi_matsu]

I have two metrics:
① Number of new sales
② Total number of sales

① The number of new sales is the number of purchases made on the date selected in the slicer.
② The total number of sales is the number of purchases made up until the date selected in the slicer.

For example, based on the data in the table below, if I select 02/2024 in the slicer, ① would be 100 and ② would be 150.

month	sales figures
1/2024	50
2/2024	100
3/2024	14
4/2024	54

Additionally, the structure of the calendar master set in the slicer is as follows, and I would like to be able to select by business year, business month, and business day.

date	business year	business month	business day
1/1/2024	2024	1	1
1/2/2024	2024	1	2
1/3/2024	2024	1	3
1/4/2024	2024	1	4

How can I achieve this?

[yoshi_matsu]

Thank you so much!

[Irwan]

hello @yoshi_matsu 

glad it works.

Thank you.

[Irwan · Accepted solution]

hello @yoshi_matsu 

please check if this accomodate your need.

create a new measure with following DAX.

Cumulative = 
var _Date = SELECTEDVALUE('Calendar'[date])
Return
SUMX(
    FILTER(
        ALL('Sales'),
        'Sales'[month]<=_Date
    ),
    'Sales'[sales figures]
)

also since you are taking calendar date as slicer, dont forget to create a relationship between those two tables.

Hope this will help.

Thank you.