Forum Discussion
Solved
Customers Rank over a period
Hi Community, I have scenario in which a customers earns points for different distribution types they have(columns values), this changes over the years. I would like to compare/rank different cli...
MarmosspinneBW
You can insert a Matrix in your report and add Year, Box, Distribution, Client in the Row section and add the following ranking measure in the value section.Client Rank= RANKX( ALLSELECTED( TableName[Client] ) , CALCULATE( SUM( TableName[Values] ) ) , ,ASC,Dense)
MarmosspinneBW
You can insert a Matrix in your report and add Year, Box, Distribution, Client in the Row section and add the following ranking measure in the value section.
Client Rank= RANKX( ALLSELECTED( TableName[Client] ) , CALCULATE( SUM( TableName[Values] ) ) , ,ASC,Dense)