Show sum of subcategories rather than calculation

[y5famfnatudu]

Hello, your help is so much appreciated.

I have a matrix that shows Procurement values, on the lowest level (products) calculations are totally right. However, the level above (Product Group) is showing unexpected values.

Here's an example:

The Power BI can be found below:
PBIX File 

Thank you so much for your kind assistance

Best regards,

Simon

[Anonymous]

Hi,

The method BeaBF provided should be helpful.

Please view the DAX formula, if the DAX formula helps, please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[BeaBF · Accepted solution]

@y5famfnatudu Hi! you have to give the granularity in the measure, try with:

Procurement 12m Diff = SUMX(VALUES('Product'[Product Name]),

([Unit Price Current (Avg)] - [Unit Price 12M Ago (Avg)])  * [Total Quantity])

If it's ok, please accept the answer as solution!

BBF