Firstly, I apologise - I am new to Powerpivot and have tried for a couple of hours to wrap my head around this DAX problem and I cannot afford to waste any more time getting gradually more and more confused. I desperately want somebody to give me a leg-up.
In excel. I am presenting a tables containing data A, B, C... X, Y in a table with slicers on "Type" and "Period". In the same data I am trying to create a permanent measure average of 123, for all the periods selected, without "123" selected in a slicer.
I've got as far this, but cannot figure out how to Average123 across the periods selected, so I'm getting the average across all periods.
<tbody>
</tbody>
A quick solution to this would be great, then I can trace it back to try to understand how it all works. I am now just too confused to understand what a FILTER, CALCULATE, AVERAGEX, measures, tables
Many thanks
In excel. I am presenting a tables containing data A, B, C... X, Y in a table with slicers on "Type" and "Period". In the same data I am trying to create a permanent measure average of 123, for all the periods selected, without "123" selected in a slicer.
I've got as far this, but cannot figure out how to Average123 across the periods selected, so I'm getting the average across all periods.
Av123:=AVERAGEX(FILTER(ALL(MyTable),[Type]="123"),[Value])
Type | Value | Period |
A | 0.1 | 1 |
B | 10 | 1 |
123 | 100 | 1 |
C | 0.1 | 2 |
D | 10 | 2 |
123 | 100 | 2 |
X | 0.1 | 3 |
Y | 10 | 3 |
123 | 100 | 3 |
<tbody>
</tbody>
A quick solution to this would be great, then I can trace it back to try to understand how it all works. I am now just too confused to understand what a FILTER, CALCULATE, AVERAGEX, measures, tables
Many thanks
Last edited: