Forum Discussion
Average for each small multiple
It seems that you're using the average from "Add further analyses to your visual" which unforunately returns the average for all. If you want the average for each small multiple by month, create a measure
Monthly Average = AVERAGEX ( ALLSELECTED ( 'Date'[Month] ), [Row Count] ) Monthly Average Label = VAR _maxMonth = MAXX ( ALLSELECTED ( 'Date'[Month] ), [Month] ) RETURN IF ( SELECTEDVALUE ( 'Date'[Month] ) = _maxMonth, [Monthly Average] )You'll need to use a custom data label to be able to show the label only for a specific data point.
Please see the attached pbix
It seems that you're using the average from "Add further analyses to your visual" which unforunately returns the average for all. If you want the average for each small multiple by month, create a measure
Monthly Average =
AVERAGEX ( ALLSELECTED ( 'Date'[Month] ), [Row Count] )
Monthly Average Label =
VAR _maxMonth =
MAXX ( ALLSELECTED ( 'Date'[Month] ), [Month] )
RETURN
IF ( SELECTEDVALUE ( 'Date'[Month] ) = _maxMonth, [Monthly Average] )
You'll need to use a custom data label to be able to show the label only for a specific data point.
Please see the attached pbix
The output you showed is exactly how I want my report to be. However I am not getting the same result. in the code above, what is [row count]?
Have you checked the pbix? The details are there. It's just the count of rows in a table.
I am using this Version: 2.139.1678.0 64-bit (January 2025). The file you attached is not supported.