Forum Discussion

Cgowdar's avatar
Cgowdar
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Displaying Top 3 and Others based on dynamic ranking

The Requirement is to show the "Top 3" and "Others" in the Pie Chart.   Following is the sample data:   Subject Student  Marks Maths John 50 Maths  Sam 60 Maths Van 70 Math...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Cgowdar

     

    You can also use a MEASURE. This will allow you to determine RANK when you select more than 1 subject

     

    RANK =
    RANKX (
        ALLSELECTED ( TableName[Student ] ),
        CALCULATE ( SUM ( TableName[Marks] ) ),
        ,
        DESC,
        DENSE
    )