Forum Discussion

jblackburnHWGA's avatar
jblackburnHWGA
Icon for Helper I rankHelper I
6 years ago
Solved

Measure help

Hi I work in a school and need a bit of help with a measure i'm having trouble with if it is in fact a measure i need 🙂   So on one of my pages I want to show top 10 or top 20 students with the hi...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    jblackburnHWGA 

     

    An alternative way to that suggested by Mariusz  is to use the TopN filter in the filter pane.

    First create a measure with the sum of the points:

    Sum of points = SUM('DataTable'[Points])

     

    Create a table visual with the student and [Sum of points] measure, and filter the table using the TopN option:

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

jblackburnHWGA 

 

An alternative way to that suggested by Mariusz  is to use the TopN filter in the filter pane.

First create a measure with the sum of the points:

Sum of points = SUM('DataTable'[Points])

 

Create a table visual with the student and [Sum of points] measure, and filter the table using the TopN option:

 

jblackburnHWGA's avatar
jblackburnHWGA
Icon for Helper I rankHelper I
6 years ago

Thank you both. I went with the second solution as I could understand it 🙂 

I have a good working top 10 list