Forum Discussion

ABMN's avatar
ABMN
Helper I
4 years ago
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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    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:

     

ABMN's avatar
ABMN
Helper I
4 years ago

jdbuchanan71 My count and percentage are both measures.  When I filter to return the top 5 I'd like my percentage to be of the total count for the date range and not just a percentage of the top 5. In your example above, when you apply the filter to only show the top 5, I'd want the percentage for Hosptial Inpatient to still be 15.53%.  Thanks again for the help.