Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |