'Dynamic average in PowerBI
I have a problem with matrices in PowerBI. I have a matrix like this:
In this matrix I have hierarchy in Rows: Group/Position/Total, where in total I take average of all numbers in this row like:
Total = CALCULATE(AVERAGE([Value]), ALLEXCEPT('Table',[Group],[Position]))
Columns are Months, where for each month I have average of values in this month for particular Group and Position
And I have data slicer. I want Total to be changed, when I move my slicer. So I want to calculate Total over dates, that are mentioned in slicer. But now Total doesn't change at all!
Please, help with this problem.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|