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,
Can you please help me with this scenario?
The matrix row gives an incorrect average. Please see image:
Solved! Go to Solution.
You may use the following measure.
Measure = IF ( HASONEFILTER ( Table1[Test] ), AVERAGE ( Table1[Value] ), AVERAGEX ( ALLSELECTED ( Table1[Test] ), CALCULATE ( AVERAGE ( Table1[Value] ) ) ) )
You may use the following measure.
Measure = IF ( HASONEFILTER ( Table1[Test] ), AVERAGE ( Table1[Value] ), AVERAGEX ( ALLSELECTED ( Table1[Test] ), CALCULATE ( AVERAGE ( Table1[Value] ) ) ) )
hi @rendalignacio,
Why are you saying that is wrong? Careful with average of averages as they are not the same of total average.
Does this make sense?
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |