Values Determined by Year and Month Filter Selection

Totally makes sense — since your values are cumulative, you don’t want to sum them when only the year is selected. Instead, you want to return the latest value from the selected period.

Here’s a DAX measure that should do the trick:

Latest Cumulative Value =
VAR SelectedYear = SELECTEDVALUE('YourTable'[Year])
VAR LatestMonth =
    CALCULATE(
        MAX('YourTable'[Month]),
        'YourTable'[Year] = SelectedYear
    )
RETURN
CALCULATE(
    MAX('YourTable'[Value]),
    'YourTable'[Year] = SelectedYear,
    'YourTable'[Month] = LatestMonth
)

Replace 'YourTable' with your actual table name, and make sure the Month column is either a proper date or has a sort order (e.g., April = 4, May = 5, etc.).

If your Month column is text (like "April", "May"), you’ll need a separate column that gives it a numeric order so MAX() works correctly.

Here’s a Microsoft doc that might help with time intelligence and filtering:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables

Let me know if you need help adapting this to your model!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.