Forum Discussion
AkrMus
Helper I
Helper IAverage with Group by DAX
Hi I have this data myRate | myDate 7 | 1 Feb 2019 3 | 14 Feb 2019 9 | 1 Feb 2019 4 | 4 Mar 2019 6 | 11 Apr 2019 3 | 13 Mar 2019...
hi, AkrMus
If you want it could be filtered by myRate , just try this formula
Measure = calculate(average( 'Table'[myRate]), FILTER(ALLSELECTED('Table'),'Table'[Month]=MAX('Table'[Month])))Result:
Best Regards,
Lin
AkrMusHelper I
Helper IMany thanks for your reply
I have tried the file you uploaded
the Mesaure average does not change based on the slicer :(
I added slicer for myRate and filtered data for myRate > 5
there was no change on the calculated column or the Measure
v-lili6-msft
Community Support
Community Supporthi, AkrMus
If you want it could be filtered by myRate , just try this formula
Measure = calculate(average( 'Table'[myRate]), FILTER(ALLSELECTED('Table'),'Table'[Month]=MAX('Table'[Month])))
Result:
Best Regards,
Lin