Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
pipanebo
New Member

How to get the value of an average measure?

Hello,

 

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

pipanebo_1-1660222638423.png

 

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:
 
pipanebo_2-1660222857970.png

 

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

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @pipanebo 

please try 

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

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @pipanebo 

please try 

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

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.