I'm having some issues trying to retrieve a total value for items that are ranked.
on my report page I have a numerical slicer which shows the top x summed sales by office.
the sum of sales is displayed using a bar graph.
I am using RANKX to determine the rank number on the selected office locations and this is all working perfectly.
what my client would like to see is the total sum of Sales for the offices that appear in the bar graph , so the sum of the sales for the top 10 locations.
they would also like to see the sum of the other locations.
the bit I am struggling with is the rankx function is performed on the office locations, which is possible because these make up the axis on the bar graph. However, when I try to retrieve the sum of these to display in a single measure I am unable due to the office locations not being filtered within the card.