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...
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.
mp390988Post Partisan
Post PartisanWill 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.