Forum Discussion
Post PartisanUnderstanding the RankX
Super UserRANKX iterates the table you provide, calculates the expression as a extra column, and ranks with that new column
With all(DimProduct) you are ranking on the entire table. With all(DimProduct[colour]) you are ranking on only a list of the distinct colours,
mp390988Ok so I guess the question I have is how does the ranking on the whole table work ? Because I don't get the same ranks when I try to work it out manually.
- Deku
Try adding each field from dimproduct into a table with sales amount. I assume you'll see a combination where blue, black, yellow, red and silver all have the same top amount.
- mp390988
Will that not be the excel file I added as a link in my original post? That excel file is the whole of DimProduct table with a calculated sales amount column right at the end.