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.
Hi
i want to create DAX Measure for to Calculate Average for 2 Columes
Can you please help me on this
Regards
Chethan
When creating measure, DAX need to evaluate with current row context so that you need to aggregate corresponding column value. You can write a measure like below:
Measure = IFERROR ( SUM ( Table[G2] ) / ( ( SUM ( Table[E2] ) + SUM ( Table[F2] ) ) / 2 ), 0 )
Regards,
Have a look at the Function called AVERAGEX, this will iterate for each row in the table.
No Can you send the Sample. how to calculate
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |