Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

conditional rank

Hello Guys.. i want to calculate the rank of column based on condition  below is my sample dataset FW Csat_num CSAT_Denom 2023-32 0 0 2023-32 1 1 2023-32 0 1 2023-32 1 2 ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Anonymous ,

     

    Try to add the following two metrics:

    CSAT = IF(COUNTROWS('Table (2)') > 5,DIVIDE( SUM('Table (2)'[Csat_num]) , SUM('Table (2)'[CSAT_Denom])))

Ranking = RANKX(SUMMARIZE(ALLSELECTED('Table (2)'), 'Table (2)'[FW], " @CSAT", [CSAT]),[ @CSAT],[CSAT])

     

     

MFelix's avatar
MFelix
Super User
3 years ago

Hi Anonymous ,

 

Try to add the following two metrics:

CSAT = IF(COUNTROWS('Table (2)') > 5,DIVIDE( SUM('Table (2)'[Csat_num]) , SUM('Table (2)'[CSAT_Denom])))

Ranking = RANKX(SUMMARIZE(ALLSELECTED('Table (2)'), 'Table (2)'[FW], " @CSAT", [CSAT]),[ @CSAT],[CSAT])