Forum Discussion
mp390988
Post Partisan
Post PartisanUnderstanding the RankX
I noticed when I replace the table ALL(DimProduct) with ALL('DimProduct'[Colour]) inside my RankX function it yields different results. I don't quite understand. I know the ranking results are incorr...
mp390988Post Partisan
Post PartisanOk 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
Super User
Super UserTry 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.