Forum Discussion

sebastianslz's avatar
sebastianslz
Frequent Visitor
3 years ago
Solved

How to get the rating average

I need to obtain the average of grades that have been assigned to the technicians who have solved ticket, the problem I have is that I only need to obtain the average of grades where they are greater than 0 and not on the total of all tickets.

I am using the Average function but it gets me the average of all tickets, I only need to get the average of tickets where their rating is greater than 0.

The following is a small example I created from the ticket table:

Ticket IDTechnicalCalification
10001Kevin0
10002Elsa0
10003Luke0
10004Bailey5
10005Billy2
10006Elsa4
10007Kevin5
10008Luke5
10009Luke5

 

Need Help
  • LuizKoller's avatar
    LuizKoller
    3 years ago

    Hello!

    AVERAGEX(
        FILTER(
            'Table',
            'Table'[Calification] > 0
        ),
        'Table'[Calification]
    )

1 Reply

  • LuizKoller's avatar
    LuizKoller
    Icon for Resolver I rankResolver I
    3 years ago

    Hello!

    AVERAGEX(
        FILTER(
            'Table',
            'Table'[Calification] > 0
        ),
        'Table'[Calification]
    )