Forum Discussion

Cris22's avatar
Cris22
Frequent Visitor
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • Cris22's avatar
    Cris22
    Frequent Visitor
    1 year ago

    Dear Joy,

     

    Thank you very much for your answer, I was using visual data segmentations on the panel, I wanted the user to chose the segmentation and the topn number. I was able to make the average work somehow. Thank u!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Cris22,

       

      If an answer has been helpful, please consider accepting the answer to help increase visibility of this question for other members of the Microsoft fabric community.

       

      Thank you for your understanding.