Promedio de 3 medidas medidas en tablas distintas

[delfina04]

Buenos días red, estoy tratando de calcular el promedio de 3 medidas. 

Tengo una tabla con los empleados y como les dio el porcentaje de cumplimineto en 3 tareas distintas. Este porcentaje de cumplimineto de las tareas esta calculada a traves de medidas, lo que quiero hacer es saber el porcentaje de cumplimineto total del empleado. Dejo la tabla que tengo, lo que busco es agregar otra columna con el cumplimiento total. 

Desde ya muchas gracias a todos por la ayuda!!

[v-kaiyue-msft · Accepted solution]

Hi @delfina04 ,

Thanks for the reply from lbendlin , please allow me to provide another insight: 

Based on your description, I created three measures.

Measure =
SUM('financials'[COGS]) / SUM(financials[ Sales])


Measure 2 =
SUM(financials[ Sales]) / SUM(financials[Gross Sales])


Measure 3 =
SUM(financials[Profit]) / SUM(financials[ Sales])

Finally, create a measure to calculate their average.

Measure 4 =
([Measure] + [Measure 2] + [Measure 3]) / 3

In case my example is different from your reality, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[delfina04]

Si funciono, muchas gracias!!

[lbendlin]

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.