RankX help

I've tried a number of solutions reading through these forums and have learned quite a bit. But I'm still struggling with this particular Ranking. Here is a sample of what my data looks like.

sup_nam	Count of Reason	Month Name 3
Manager 1	16	January
Manager 1	12	February
Manager 2	11	January
Manager 2	21	February
Manager 3	20	January
Manager 3	15	February

When I apply the rank using a filter for one month I get the rank I'm looking for.

Filtered Jan	Count of Reason	Rank
Manager 2	12	January	1
Manager 1	16	January	2
Manager 3	20	January	3

However when I have multiple months selected I get where each Manager is ranked for each month instead of being ranked by the total reasons.

Filtered Jan & Feb	Count fo Reason	Rank
Manager 2	11	January	1
Manager 1	12	February	2
Manager 3	15	February	3
Manager 1	16	January	4
Manager 3	20	January	5
Manager 2	21	February	6

Here is my measure;

RankingMeasure =

IF (

ISFILTERED ( 'Manager Totals By Month'[Month Name 3] ),

RANKX (

ALLSELECTED ( 'Manager Totals By Month' ),

CALCULATE ( SUM ( 'Manager Totals By Month'[CountofReason] ) ),

asc

RANKX (

ALL ( 'Manager Totals By Month' ),

CALCULATE ( SUM ( 'Manager Totals By Month'[CountofReason] ) ),

asc

)

Thanks for all the previous help and the help on this.

Need Help

Anonymous

7 years ago

How about this:

RANKX = 
IF ( 
    HASONEVALUE( 'RankX Help'[sup_nam]),
    RANKX( 
        ALL('RankX Help'[sup_nam]), 
        [Total Count of Reason],,ASC,Dense
    )
)

Looks like it produces what you are after:

Manager 1	28	N/A	1
Manager 2	32	N/A	2
Manager 3	35	N/A	3

Forum Discussion

RankX help

6 Replies

Related content

RankX

RANKX

Advanced Ranking (Rankx)

Rank vs Rankx

RankX