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:

     

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

You will have to modify your % measure to use ALLSELECTED probably.

ABMN's avatar
ABMN
Helper I
4 years ago

jdbuchanan71   Here is what I have

 

Count = COUNT('servicedesk BIA_tickets'[request_number])
SelectedTotal = CALCULATE('servicedesk BIA_tickets'[Count],ALLSELECTED('servicedesk BIA_tickets'))
PercentageOfSelected = DIVIDE('servicedesk BIA_tickets'[Count],'servicedesk BIA_tickets'[SelectedTotal])
 
PercentageOfSelected is what I am using in the table.