- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Year wise calculation
Hi Community..!!
Please refer the above image,
Product-Backend is coming from Product table
Year is coming from Date table
I want to display in column Market Growth YOY - value of 2022 will sum i.e 13474 + 3381 = 16855 and value of 2023 will sum i.e 12698 + 8659 = 21357
and result will diplay like this
2022 16855
2022 16855
2023 21357
2023 21357
Could you please help me to resolve this.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
Thanks for TomMartens and dharmendars007 reply. If you have not solve the problem. You can try using the following measure.
My Model:
Market Growth YOY =
CALCULATE (
SUMX ( 'Product', 'Product'[Value] ),
ALLEXCEPT ( 'Product', 'Date'[Year] )
)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
Thanks for TomMartens and dharmendars007 reply. If you have not solve the problem. You can try using the following measure.
My Model:
Market Growth YOY =
CALCULATE (
SUMX ( 'Product', 'Product'[Value] ),
ALLEXCEPT ( 'Product', 'Date'[Year] )
)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello @Anonymous ,
You can use the below formula pattern to achieve the result you are looking for..
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @dharmendars007
Its showing below result if i use your dax code
But my requirement is different - you can refer my question.
Thanks..!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey @dharmendars007 ,
I'm wondering about the difference between your solution and mine because:
- your solution does not state if it's a measure or a calculated column
- your solution does not reflect on the different tables, like the Date and Product table
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey @Anonymous ,
you have to create a measure, this will do the trick:
Market Growth YOY =
CALCULATE(
SUM('<the table namw>'[Value]),
ALL('Product'[Product-Backend])
)
Hopefully, this creates what you are looking for.
If not, create a pbix file that contains sample data, but still reflects your semantic model (tables, relationships, calculated columns, and measures), upload the pbix to OneDrive, Google Drive, or dropbox and share the link. If you are using a spreadsheet to create the sample data, instead of the manual input method, share the spreadsheet as well.
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey @Anonymous ,
you can try this:
Market Growth YOY =
CALCULATE(
SUM('<the table namw>'[Value]),
ALL('Product'[Product-Backend]),
'Product'[Product-Backend] in { "Aimovig / ..." , "Ajovy / ..." }
)
Make sure that you provide the 2 items from the Product-Backend column shown in your image.
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-01-2024 07:54 AM | |||
09-19-2024 12:01 PM | |||
01-24-2025 09:19 AM | |||
04-18-2024 12:55 PM | |||
01-30-2025 08:30 AM |