Forum Discussion
Ranking Matrix Country by Sales
I have done quite a few searches on this topic and there is lots of information on it. Unfortunately I am new to power bi and really struggling to understand how to take someone elses solution and mo...
you can use a calculated coumn to give your countries a rank and use sort by column function to sort countries in the matrix visual. To group other countries that do not fall in your top 10 category use grouping function and manually select the countries and group them together
What am I missing on the ranking formula?
Country NST RANK Col = RANKX(ALL(Summary[Buyer Country Description]), SUMX(RELATEDTABLE(Summary), [Final NS&T]))
Its only returning 1 for everything and then the last one is 153. I was thinking it would be straightforward since both values are on the same Summary table.