Get sum of year to date values before selected date

[Anonymous]

Hi there

I have sample data that looks like this

And some charts like this

When I select a month in the column chart, I wish for the 'sum of reg year value' card to show the sum of values <= the selected month but within the reg year.

For example if I select 'Sep 2023' the card should display the value 23

I've tried using the SELECTEDVALUE() function but to know success.

Thanks for any help

[Jihwan_Kim · Accepted solution]

Hi,

I do not know how your semantic model looks like but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file if it suits your requirement.

expected result measure: =
CALCULATE (
    SUM ( Data[Value] ),
    Data[Date] <= MAX ( Data[Date] ),
    Data[isRegYearFlag] = "Y"
)