Year wise calculation

[Anonymous]

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.

[v-yaningy-msft · Accepted solution]

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

[dharmendars007]

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

LinkedIN 

[Anonymous]

Hi @dharmendars007 
Its showing below result if i use your dax code 

But my requirement is different - you can refer my question.

Thanks..!!

[TomMartens]

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

[TomMartens]

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

[Anonymous]

Hi @TomMartens 

Its showing below result if i use your dax code.

[TomMartens]

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