topic Re: How to get the value of an average measure? in DAX Commands and Tips

How to get the value of an average measure?

pipanebo — Thu, 11 Aug 2022 13:08:13 GMT

Hello,

I need to get the value, just the "141,02", from an average measure. As shown below:

To get to this number I used these formulas:

Soma Horas = SUM(Rel_Ciclo[T0 Ciclo])

Média T0 CB = AVERAGEX(VALUES(Rel_Ciclo[Equipamento]),[Soma Horas])

Média em valor = AVERAGEX(VALUES(Rel_Ciclo[Equipamento]),Medidas[Média T0 CB])*24

My database is something like this:

Is there a way to get just the 141,02 value? I need to divide another measure by this number.

Re: How to get the value of an average measure?

tamerj1 — Thu, 11 Aug 2022 13:31:16 GMT

Hi pipanebo

please try

Média em valor All =
CALCULATE ( [Média em valor], ALLSELECTED ( Rel_Ciclo[Equipamento] ) )

Re: How to get the value of an average measure?

pipanebo — Thu, 11 Aug 2022 13:50:57 GMT

Hello tamerj1.

It worked. Thank you very much. I just had to switch the "CALCULATE ( [Média em valor], ALLSELECTED ( Rel_Ciclo[Equipamento] ) )" for another column and it worked.