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.
Good afternoon,
Thanks for your help, with what you told me, and tracing the problem, I came to the conclusion that my problem was that the topn was returning more than n values as there were some repeated values. As I have not really managed to solve it using formulas in dax, after much thought, I have had no choice but to add to the data an index column and another [modified speed] = [speed]+[index]/100000000.
Thank you