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

[ganc]

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.

[v-shex-msft]

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

[mh2587]

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 %)