Forum Discussion
Solved
Ranking Help
Hi All I'm new to Power BI and i am needing some help on ranking My source data has a list of all the individual sales that have been made throughout the year. I want to be able to rank the s...
You can achieve your results with the below measure. Depending on what you put on the matrix the measure may change
=
IF (
ISFILTERED ( Table1[SalesRep] ),
RANKX ( ALLSELECTED ( Table1[SalesRep] ), [TotRevenue] ))
where TotRevenue is a Measure = SUM( Table1[Revenue] )
You can achieve your results with the below measure. Depending on what you put on the matrix the measure may change
=
IF (
ISFILTERED ( Table1[SalesRep] ),
RANKX ( ALLSELECTED ( Table1[SalesRep] ), [TotRevenue] )
)
where TotRevenue is a Measure = SUM( Table1[Revenue] )