Total sum of avg

[mikel1380]

Hello Pals,

maybe you can helpme. I need get total sum of avg by type.

ex:

 

 i need this (Yellow):

thanks a lot

[BILASolution · Accepted solution]

Hi @mikel1380

Try this...

1. My sample data: Table "Promedio"

2. I created the next measures...

Promedio Value = AVERAGE(Promedio[Value])

Suma Promedio = SUMX(SUMMARIZE(Promedio;Promedio[Clase];Promedio[Letter];"Promedio";AVERAGE(Promedio[Value]));[Promedio]) 

3. The result is...

I hope this helps

Regards

BILASolution

[caaromeroba]

I have a similar problem, a need to sum the avg of all kind. This is my dates. 

In this example i have Disposal and this one is constituted by Disposal 1, disposal 2 .. etc... each disposal have many value of Barriles, and i want the avegared of each PUNTO and then sum this average.

I need to make a KPI with that.... thank you very much¡¡

[caaromeroba]

I have a similar problem, a need to sum the avg of all kind. This is my dates. CLASE TIPO VALOR AVG A T1 7 A T2 6 A T3 9 TOTAL SUM(7,6,9) ? In power Bi, if i put avg the total is a avg, i need to search the sum of the all avg of each TIPO..... I NEED MAKE A KPI with that. Thank you¡¡¡

[caaromeroba]

I have a similar problem, a need to sum the avg of all kind.

This is my dates.

[caaromeroba]

I have a similar problem, a need to sum the avg of all kind.

This is my dates.

[mikel1380]

Thanks a lot my friends!!!, it worked great. 

Greetings.