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

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

Mking4646's avatar
Mking4646
Frequent Visitor
4 years ago

that would be incredible please