Forum Discussion
Cgowdar
Advocate II
8 years agoDisplaying 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...
- 8 years ago
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 )
Zubair_Muhammad
Community Champion
8 years agoCgowdar
Advocate II
8 years agoYes , Exactly