Forum Discussion

Navaneeth_'s avatar
Navaneeth_
Regular Visitor
3 years ago

RANKX

I have a Email Interactions table which is at Interaction_ID and SDR_NAME(Sales rep name) level. I want to rank them based on a score (A measure), I'm using the below formula, using ALL() for the ran...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Navaneeth_ 
Please try

Email Rank =
RANKX (
    ALL ( 'SALESLOFT_DETAILS'[SDR_NAME] ),
    CALCULATE ( [Email_Score] + [Email_Reply_Score], ALL ( 'Table'[Date] ) ) / 2,
    ,
    DESC,
    DENSE
)