Forum Discussion

MarmosspinneBW's avatar
MarmosspinneBW
Frequent Visitor
4 years ago
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 clients aganist each other for different years & different box types .

Ideally I would like  to see each clients rank against others for a particular year, particular box and distribution type. 

 

Sample data 

 

Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    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)

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    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)