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.
Hello,
I'm trying to calculate the total average of sales units across a dimension in a matrix. Here is my current formula:
Sales Avg Sum = averagex(ALL('Reports DM_STORE'[Store Number]),[Sales Units])
Solved! Go to Solution.
Try the below
Sales Avg Sum = AVERAGEX( ALL( 'Reports DM_STORE'[Store Number], 'Reports DM_STORE'[Store] ), -- OR ALL( 'Reports DM_STORE' ) [Sales Units] )
Try the below
Sales Avg Sum = AVERAGEX( ALL( 'Reports DM_STORE'[Store Number], 'Reports DM_STORE'[Store] ), -- OR ALL( 'Reports DM_STORE' ) [Sales Units] )
Have you tried just
Sales Avg Sum = average('Reports DM_STORE'[Sales Units])
That should average all the numbers of Sales Units.
Help when you know. Ask when you don't!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |