Forum Discussion
Solved
Column topn average
Dear all,I would be grateful if you could help me with the following question: I have a table (Data) with speeds for different drivers on different laps of a track and for different years and sessio...
Hi Cris22 , lbendlin, thank you for your prompt reply!
Make your filter on page then show the average value in card as shown below:Top2SpeedAverage = VAR TopSpeeds = TOPN( 2, ALLSELECTED('Table'), 'Table'[SPEED], DESC ) RETURN AVERAGEX(TopSpeeds, 'Table'[SPEED])Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Remember you are operating in the current filter context (assuming you use a measure) so there is no need to specify extra filters.
All you need is to divide the sum of the top two speed entries by 2 (or do an averagex if so inclined)