I have some issues with the total row in a pivot table. The screenshots I will show, will be taken from an Excel file that I made as an example.
In the total row, I have two weighted averages. The "€ case 2" is correct because the measure is more simple I think. The "€ case 1" total result, which is red (0.120 €), is what I get instead of the green one (0.585 €).
Here's my measure (it works fine in the table rows)
How can I fix the measure in order to get the result I want, without affecting the rows of the table?