I am using a data model with Power Pivot:
The first column is called "Description" and the second column is a RANKX function based on a third column. I want to use Cube functions to get the TOP 10 descriptions based on the ranked on Excel.
With this formula I get the top 10 fields from the ranked column:
And I have the ranking top 10 if I drag the formula 10 cells:
How can I get the descriptions based on that column with cube formulas?