I am having an issues ranking a set of rows then getting the total to use as input to another calculation. I have attempted nested CALCULATE statements and intermediate table using CALCULATETABLE unsuccessfully. Scenario is as follows:
Original table
Item Sales
A 3
B 4
C 2
D 7
E 5
Ranking top N (3)
Item Sales
D 7
E 5
B 4
TOTAL 16
In this example, I am interested in the value 16 for onward processing