Forum Discussion
RANKX Based on a Text Measure Column
Salaam All, Please if you don't mind helping on this, I have a case where i want to rank a text measure [Optimization PCP] where i can get the desire output as in [Optimization RANK]. The cas...
Hi, Try this if it helps you :
Optimization Rank =
RANKX(
FILTER(
ALL('YourTable'[Name], 'YourTable'[Year-Month]),
'YourTable'[Name] = MAX('YourTable'[Name]) && 'YourTable'[Year-Month] = MAX('YourTable'[Year-Month])
),
[Optimization PCP],, DESC, Dense
)
kindly accept as a solution if it works with you
