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.
Good Day
PowerBi Link: https://drive.google.com/drive/folders/1l0H90UpW0LLzvOEnntJBa9eD2Kfimvss?usp=sharing
My measure works perfectly for combined branches of average units.
However, when I split it by branch, the inidvidual branch average units doesn't equal the total ave units. I think this is due some months having no sales for some months.
Ave units all branches: 871
Ave Units: Asia (214) + Canada (315) + Europe (139) + South Africa (257) = 925 units
Below is my measure:
Hi,
Averages are never additive. To get a grand average, one cannot add individual averages. Therefore the results in your post might be correct.
@bvanderwatt , Assume you have measure unit ,
Then try measure like
averageX(Values(Date[YYYY-MMM]) , [Unit])
if you want to do it on a column
averageX(Values(Date[YYYY-MMM]) ,calculate(sum(Table [Unit])) )
This will sum till month level and Avg above it
Thank you so much. I need to use completed months. Therfore, I need to exclude August which is the current month.
Please see below my formula. Hoping this will be a quick fix 🙂
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 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |