Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ranking

Hello,   I have 2 tables Carrier group - gives me a carrier groups numbers and it ranks them by a changing measurement. Carrier - Gives me each carrier and ranks them by the same changing measur...
Need Help
AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

I think you need to avoid the filtering of the carrier group in the carrier rank. Try this:

 

Carrier  Rank =
RANKX (
    ALL ( Data[CARRIER_CODE], Data[Carrier Group] ),
    'Period Dimmension'[Period Selection],
    ,
    0
)

  Or in fact, if carrier group filters the carriers, as I guess it does, this should probably suffice:

 

Carrier  Rank =
RANKX (
    ALL ( Data[Carrier Group] ),
    'Period Dimmension'[Period Selection],
    ,
    0
)