Promedio de Promedios por Jerarquia de Colaboradores

[MarcoPol_79]

Hola a Todos

Si alguien puede ayudarme se los agradecería mucho:

Tengo dos visuales, los cuales apuntan a dos tablas diferentes, esto con el promedio de productividad de colaboradores, de los gerentes de esos colaboradores y el promedio del equipo se sube a cada gerente.

Los promedio del equipo de trabajo suben bien en el visual "7 Productividad Gerencia Titular" en la columna "%Equipo"; sin embargo, el promedio total de la columna no es correcto, obtiene el promedio del equipo total de trabajo del visual 5, pero lo que busco es el promedio de promedios que sería el promedio reultante de (63.60 y 45.30) o sea 54.45.

El tema es que son medidas, ejemplo:

8MAUD Logro Inicial =
VAR Sum_Ops =
SUM('Auditores'[ops_audit_hours])
return
DIVIDE(Sum_Ops,[7MAUD Horas_meta])

Con esta medida obtengo el Logro Inicial de los auditores que se convierte en "%Equipo en el visual 7, esto es porque son registros mensuales, existen por lo menos 5 registros por persona.

Saludos

[v-tsaipranay]

Hi @MarcoPol_79 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-tsaipranay]

Hi @MarcoPol_79 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay · Accepted solution]

Hi @MarcoPol_79 ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

From what I understand, you are trying to calculate the average of team averages at the manager level in Visual 7, but the total shown is instead aggregating all underlying data points across all teams, which skews the result.

This behavior is expected in Power BI since totals for measures are re-evaluated at the visual level, not simply summed from the visible rows.

To get the desired result the true average of the %Team values per manager you need to force row-wise evaluation using a pattern like:

AverageOfAverages = 
AVERAGEX(
    VALUES('ManagerTable'[ManagerID]), 
    [Your_Per_Manager_Measure]
)

The SUMX/AVERAGEX approach over a distinct list of managers ensures each row is individually calculated, and then properly aggregated.

Ace @amitchandak answer with SUMX(VALUES(...), CALCULATE(...)) is aligned with this approach and should resolve your issue. You can adapt it by switching to AVERAGEX if your goal is the mean rather than sum.

I hope this will help you understand better, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

[v-tsaipranay]

Hi @MarcoPol_79 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[amitchandak]

@MarcoPol_79 , Avg of Avg, you have to force using Summarize or values

return

Sumx(Values(Table[ID]), calculate(DIVIDE(Sum_Ops,[7MAUD Target_hours])) )

example- Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980