How to take a measure of Total Cost and create 2 new measures: 2023 Costs and 2024 Costs?

[fancyonion1021]

Hi! New user here. My overall task is to create a 2024 goal measure which is 70% of the 2023 Costs. I was thinking the first step would be to separate Total Costs into 2 measures: 2023 and 2024 Costs. Can you please help? I have troubleshoot many forums and YT videos with no success. TIA

[Anonymous · Accepted solution]

Hi, @fancyonion1021 

Based on you description, you can try the following measure.

2023 Costs = 
CALCULATE(SUM('Table'[Quantity]),'Table'[Date].[Year] = 2023,ALL('Table'))

2024 Costs = 
CALCULATE(SUM('Table'[Quantity]),'Table'[Date].[Year] = 2024,ALL('Table'))

2024 goal = 
CALCULATE(SUM('Table'[Quantity]) * 0.7,'Table'[Date].[Year] = 2023,ALL('Table'))

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum