Forum Discussion
Solved
Dynamic Ranking Based on Date Slicer
I have a report shown below that shows the number of help desk tickets and the percentage by department for a given date range, using a date slicer. I would also like to be able to apply a dynamic r...
I will use my model just for the example. I have claims data that has a field 'Benefit'. If I want to rank the benfit based on the % of paid it would look like this.
Benefit Rank = IF ( ISINSCOPE ( vCLAIM[Benefit] ), RANKX ( ALLSELECTED ( vCLAIM[Benefit] ), [Paid % of Total Paid] ) )I use ISINSCOPE so it doesn't give me a 1 on the total row for the rank.
Then I can apply a filter to the visual for that measure:
I will use my model just for the example. I have claims data that has a field 'Benefit'. If I want to rank the benfit based on the % of paid it would look like this.
Benefit Rank =
IF (
ISINSCOPE ( vCLAIM[Benefit] ),
RANKX ( ALLSELECTED ( vCLAIM[Benefit] ), [Paid % of Total Paid] )
)I use ISINSCOPE so it doesn't give me a 1 on the total row for the rank.
Then I can apply a filter to the visual for that measure:
That worked great. Thank you.
