Forum Discussion
Ranking 2 Measures and Filtering
Sean sure here you go:
Entry % = sum('All Mults Data'[Entry Response])/counta('All Mults Data'[Entry Response] )
Count of Entry = count('All Mults Data'[Entry Response])
Initially I didn't have Count of Entry as a measure, I just has COUNT('All Mults Data'[Entry Response]) in where the second measure would appear, but this didn't work either.
mjholland on the 3rd, 4th and 6th lines ONLY add the column name
so it will look like => ALL ( 'All Mults Data'[Branch Name] )
Also change to counta the 2nd measure or the 1st to count depending on your data type
You're a hero, it's worked!
Here's what I've ended up with:
Final Rank =
RANKX (
ALL ( 'All Mults Data'[Branch Name] ),
RANKX ( ALL ( 'All Mults Data'[Branch Name] ), [Entry %],, ASC )
+ DIVIDE (
RANKX ( ALL ( 'All Mults Data'[Branch Name] ), [Count of Data Points],, ASC ),
( COUNTROWS ( ALL ( 'All Mults Data' ) ) + 1 )
)
)For [Count of Data Points] I've used COUNTA rather than COUNT, which has given me the result I'm looking for.
It works with all the filtering too. Thanks for all your help.
MJHolland
How can i rank as per a dynamic measure, not a fixed column.
I want to create a rank measure, using 2 measures, not 2 columns. Rankx seems to work only for columns in tables.