Forum Discussion
Average by Column then Percent Difference
Hi,
thanks a lot for your answer.
I am trying to calculate the average of the values within a specific category and to then calculate the percentage change from the average for each of these values .
| Fruits Category | Fruits | Volume | Current Average Calculation | Desired Average Calculation | Percentage Change |
| Berries | Blueberry | 31 | 31 | 1,212 | -97.44% |
| Boysenberry | 329 | 329 | 1,212 | -72.86% | |
| Cranberry | 65 | 65 | 1,212 | -94.64% | |
| Currants | 7,297 | 7,297 | 1,212 | 501.92% | |
| Gooseberry | 66 | 66 | 1,212 | -94.56% | |
| Loganberry | 225 | 225 | 1,212 | -81.44% | |
| Raspberry | 473 | 473 | 1,212 | -60.98% | |
| Total | 8,486 | 1,212 | 1,212 |
The "Current Average Calculation" in blue is what I am currently getting with the following formula:
The total is correct but the problem is that I would like to have this total displayed on each row (Desired Average Calculation) instead to then be able to calculate the percentage change. Exactly what you showed in your screenshot above.
As a side note, the fruits category is selected in the filter panel and it applies for the whole page but there are also some slicers on the dashboard. I would like these calculations to adjust accordingly to the filters selected in the slicers.
Many thanks in advance for your input.
Any suggestion would be really appreciated.
Hi,
Share the download link of the PBI file.
Thank you very much.
I found the solution by myself in the end.