Forum Discussion

Mking4646's avatar
Mking4646
Frequent Visitor
4 years ago
Solved

2 things I need help with please! Ranking Individual Measures in a Powerpivot Table &&

Hello, i'm trying to create new columns on the pivot that display the rank of each individual measure here i.e                      revrank Lengthrank RecencyRank QuantityRank customer 100  ...
DAX Filtering
DAX RANKX
  • tamerj1's avatar
    tamerj1
    4 years ago

    Mking4646 

    Please try

    =
RANKX (
    ALLSELECTED ( Table1[Customers] ),
    CALCULATE ( [Measure], ALL ( Table1[URN] ) )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Mking4646 

Please try

=
RANKX (
    ALLSELECTED ( Table1[Customers] ),
    CALCULATE ( [Measure], ALL ( Table1[URN] ) )
)
Mking4646's avatar
Mking4646
Frequent Visitor
4 years ago

HERO!😍

 

thats worked perfectly with having both in rows!

 

Thank you very much!

 

i'll continue to play around with last salesperson bits you mentioned previously and hope i can crack it

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hey..
    Would you like to join with teams or zoom?

    • Mking4646's avatar
      Mking4646
      Frequent Visitor
      4 years ago

      that would be incredible please