How to get the rating average

[sebastianslz]

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 ID	Technical	Calification
10001	Kevin	0
10002	Elsa	0
10003	Luke	0
10004	Bailey	5
10005	Billy	2
10006	Elsa	4
10007	Kevin	5
10008	Luke	5
10009	Luke	5

[LuizKoller · Accepted solution]

Hello!

AVERAGEX(

    FILTER(

        'Table',

        'Table'[Calification] > 0

    ),

    'Table'[Calification]

)