Forum Discussion

ganc's avatar
ganc
New Member
4 years ago

TICKETS SYSTEM / RANK EMPLOYEES by % / CLOSED TICKET WITHIN RESOLUTION TIME

How can I do a Rank of employees by % of tickets closed on time? 

 

Closed on time column contais values = Yes, No, Open

 

So I need the % of Yes out of total number tickets assigned to the employee and that should give me a rank for employees.

 

 

2 Replies

  • mh2587's avatar
    mh2587
    Icon for Super User rankSuper User
    4 years ago
    Measure %=
VAR CountYes=
    CALCULATE ( COUNTROWS ( Table Name ), ( Table Name[Closed on time] ) == "Yes" )
VAR Total_Count =
    CALCULATE ( COUNTROWS ( Table Name ) )
RETURN
    DIVIDE ( CountYes, Total_Count,0)


    Measure Rank = RANKX(Table Name,measure %)
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ganc,

    According to your description, it seems like you haven't shared any detailed information and sample data.

    Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng