Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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:
Is there a way to get just the 141,02 value? I need to divide another measure by this number.
Solved! Go to Solution.
Hi @pipanebo
please try
Média em valor All =
CALCULATE ( [Média em valor], ALLSELECTED ( Rel_Ciclo[Equipamento] ) )
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 20 | |
| 12 | |
| 11 |