Show sum of only selected values

[Username1848]

Hello all,

I have a table with sales from different years (and different customers, but this isn't too important for my question).

I want to create a measure that calculates the sum of the values (from "Value") of only the selected years in the "Category" column. I pasted an exemplary table below. I want to e.g. filter "Category" for the years 2024, 2025, and 2026 and get the result of the values of 81.000.

I tried with this measure, but it won't display the visual:

Sales 23 (€) Selected Category = CALCULATE(SUM('sales planning 2023'[Value]),FILTER('sales planning 2023',SELECTEDVALUE('sales planning 2023'[Category])))

Customer	Category	Value
A	Sales 2023	10.000
B	Sales 2023	9.000
C	Sales 2023	12.000
A	Sales 2024	12.000
B	Sales 2024	11.000
C	Sales 2024	14.000
B	Sales 2025	11.000
C	Sales 2025	5.000
A	Sales 2026	14.000
C	Sales 2026	14.000
C	Sales 2027	9.000
A	Sales 2028	12.000
B	Sales 2028	12.000
C	Sales 2028	10.000
C	Sales 2029	11.000
B	Sales 2030	9.000
C	Sales 2030	12.000
A	Sales 2031	10.000

Any help is highly appreciated! Best regards

[Ritaf1983 · Accepted solution]

Hi @Username1848 
If I understand you, you want to calculate an amount based on the context of a filter.
It's just a simple sum formula.
See attached image and file for an example
If not, please provide an example of what you are attempting to accomplish

Link to sample file 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Username1848]

Hi @Ritaf1983, thanks for your reply! I only now realize that I didn't describe my actual problem. I want to close this threat and open another where I describe my problem in more detail.

For the above described question, your answer is correct, thanks.