Average of average of average

[Mhuanca89]

Hello community, i've been trying with no success, to get average per turn (turn day, turn night), and machine (machine 1, machine 2, etc.) but it turns out that some Sites don't have the same number of machines.

MH% Humedad Torta Prensa OK =
var PromDiaPrensa01Humedad = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),
Caracteristica[Id]=164,
Fase[Fase]=("PRENSA N°01"),
Horario[Horario]="Día")
var PromDiaPrensa02Humedad = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),
Caracteristica[Id]=164,
Fase[Fase]=("PRENSA N°02"),
Horario[Horario]="Día")
var PromNochePrensa01Humedad = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),
Caracteristica[Id]=164,
Fase[Fase]=("PRENSA N°01"),
Horario[Horario]="Noche")
var PromNochePrensa02Humedad = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),
Caracteristica[Id]=164,
Fase[Fase]=("PRENSA N°02"),
Horario[Horario]="Noche")
var PromDiaPrensa03Humedad = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),
Caracteristica[Id]=164,
Fase[Fase]=("PRENSA N°03"),
Horario[Horario]="Día")
var PromNochePrensa03Humedad = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),
Caracteristica[Id]=164,
Fase[Fase]=("PRENSA N°03"),
Horario[Horario]="Noche")

RETURN
(PromdiaPrensa01Humedad + PromDiaPrensa02Humedad + PromNochePrensa01Humedad +PromNochePrensa02Humedad +
PromDiaPrensa03Humedad + PromNochePrensa03Humedad )/6

In return, i need to count a dynamic value, not static.

I deeply thanks in advance for any insights in how to solve this problem!

My best Regards !

[Greg_Deckler]

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Mhuanca89 · Accepted solution]

@Greg_Deckler ... maybe.. but finders keepers

i got the solution....

MHOK_% Grasa de Prensa =

var PromDiaPrensa01Grasa = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),

Caracteristica[Id]=163,

Fase[Fase]=("PRENSA N°01"),

Horario[Horario]="Día")

var PromDiaPrensa02Grasa = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),

Caracteristica[Id]=163,

Fase[Fase]=("PRENSA N°02"),

Horario[Horario]="Día")

var PromDiaPrensa03Grasa = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),

Caracteristica[Id]=163,

Fase[Fase]=("PRENSA N°03"),

Horario[Horario]="Día")

var PromNochePrensa01Grasa = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),

Caracteristica[Id]=163,

Fase[Fase]=("PRENSA N°01"),

Horario[Horario]="Noche")

var PromNochePrensa02Grasa = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),

Caracteristica[Id]=163,

Fase[Fase]=("PRENSA N°02"),

Horario[Horario]="Noche")

var PromNochePrensa03Grasa = CALCULATE(AVERAGE('Detalle Registro Controlprocesos'[Valor]),

Caracteristica[Id]=163,

Fase[Fase]=("PRENSA N°03"),

Horario[Horario]="Noche")

var DiaPrensa01 = IF(PromDiaPrensa01Grasa>1,1,0)

var DiaPrensa02 = IF(PromDiaPrensa02Grasa>1,1,0)

var DiaPrensa03 = IF(PromDiaPrensa03Grasa>1,1,0)

var NochePrensa01 = IF(PromNochePrensa01Grasa>1,1,0)

var NochePrensa02 = IF(PromNochePrensa02Grasa>1,1,0)

var NochePrensa03 = IF(PromNochePrensa03Grasa>1,1,0)

RETURN

(PromDiaPrensa01Grasa + PromDiaPrensa02Grasa + PromDiaPrensa03Grasa +PromNochePrensa01Grasa + PromNochePrensa02Grasa + PromNochePrensa03Grasa )/(DiaPrensa01 + DiaPrensa02 + DiaPrensa03 +NochePrensa01 + NochePrensa02 + NochePrensa03)

thanks in advance