Forum Discussion

ckausihan_12's avatar
ckausihan_12
Icon for Helper I rankHelper I
5 years ago

Sum first 3 ranks

Hi, I have a table with students results and I want to sum the top 3 grades. However, a student can have the same subject multiple times with the same result. I am putting the grades into a ranking o...
Need Help
Show and Tell
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ckausihan_12 , Try like

Top 3 = CALCULATE(sum('Table'[grade_sum]),TOPN(3,ALL ('Table'[grade]),calculate(MAX('Table'[grade])),DESC),VALUES('Table'[grade]))