The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |