Forum Discussion
Year wise calculation
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 TeamIf 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
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
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