Forum Discussion
Exam Item Analysis
Hi, Newbie here. How can I sum the Item No.1 based on the Score Column. But before to get the SUM of Item No. 1, I need to Sort Descending order the Score Column because I need only those top N ...
Hi Anonymous
The Unique Ranking is already solved.
I just want to clarify this formula
BottomN_Sum =
CALCULATE(
SUM('YourTable'[Item No.1]),
FILTER(
'YourTable',
'YourTable'[Rank] > (MAXX(ALL('YourTable'), 'YourTable'[Rank]) - N) // Replace N with the number of bottom scores you want
)
)
Because this formula does not functioning.
I already have Unique Ranking of Row but I want is to Sum the TopN and BottomN based on Ranking Column.
Thank you