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 All,
I am trying to figure out how to approach this calculation.
I have three measures per day. I need to average each days average and then take the average of those averages over a given time.
Day | Item1 | Item2 | Item3 | Average |
Monday | 1 | 1 | 3 | 1.66666667 |
Tuesday | 2 | 2 | 2 | 2 |
Avg. Of Avg | 1.83333333 |
What I am ultimately looking for is the number that is in red. I can do this in excel super quick but cant seem to rationalize how to get the same result in PowerBI.
Perhaps I am overthinking this but I cant seem to work this one out!
THanks,
Nick
Solved! Go to Solution.
I used GROUPBY to create a DAX table and then calculated the Average per line. I was then able to use this. Thanks for the ideas guys!!!
I didnt properly lay out how my data is formatted. It is more like what is below.
What I want to calculate is the numbers in red ultimately.
I already have the "yellow" and "Blue" groups set up with relationships.
The average section is the sum of time / sum of calls. So it is actually a averate time/call type measurement.
Any thoughts?
I used GROUPBY to create a DAX table and then calculated the Average per line. I was then able to use this. Thanks for the ideas guys!!!
hi,
If the value in red is all you need, just insert a measure.
Measure = AVERAGE('name of your table'[Average])
I think you are struggling because of how your data is set up ( assuming what you put below is how it is set up). But going off that just did a simple unpivot other column in Power Query:
Then it's just a simple average formula:
Avg = AVERAGE('Avg of Avg'[Value])
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |