Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am very new to Power BI and Still not understanding the difference between calculating a column vs calculating a measure.
Below I am working on a DAX that is giving me different values for the same formula.
Column 3 = Divide ( Sum ( column ), Sum(Loads)) = 2.3, 0.24, etx
Measure = Column divided by Loads = Divide ( Sum ( column ), Sum(Loads)) = 3%, 5.9%. which is correct.
The reason I need to use the column is so I can take the average of that column and display it on a grap. I am not able to take an averge of the measure. My question is how could I get the correct results with the Column formula.
Column Loads Column 3 (DAX) Measure ( Loads Divided by Column)(DAX)
0 317 2.32
1 33 0.24 3%
0 79 0.57
2 34 0.24 5.9%
Solved! Go to Solution.
Hi @Anonymous ,
You'd better create measures.
Calculated Columns vs Measures
Measure 2 =
DIVIDE(
MAX('Table (3)'[Column]),
MAX('Table (3)'[Loads])
)
Average_measure =
AVERAGEX(
ALL('Table (3)'),
[Measure 2]
)
If you want to create columns, you can do like this:
Column 2 =
DIVIDE(
'Table (3)'[Column],
'Table (3)'[Loads]
)
Average_column = AVERAGE('Table (3)'[Column 2])
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You'd better create measures.
Calculated Columns vs Measures
Measure 2 =
DIVIDE(
MAX('Table (3)'[Column]),
MAX('Table (3)'[Loads])
)
Average_measure =
AVERAGEX(
ALL('Table (3)'),
[Measure 2]
)
If you want to create columns, you can do like this:
Column 2 =
DIVIDE(
'Table (3)'[Column],
'Table (3)'[Loads]
)
Average_column = AVERAGE('Table (3)'[Column 2])
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Refer: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
In column you should try lik
Column 3 = Divide ( [ column ], [Loads]) = 2.3, 0.24, etx
Then use Avg Measure = Average(Table[Column 3])
This one is correct
Measure = Column divided by Loads = Divide ( Sum ( column ), Sum(Loads))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |