Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to get an average calculation via Quick Measure in Power BI to match how an Excel Pivot table does the calculation.
There are tickets which are sent to another department and come back after a task is completed. Usually this is 1-3 days, which the Excel Pivot Table average shows. For some reason my quick measure for average is showing much higher, over 13.
How can I emulate an Excel Pivot table Average using Quick Measure? Screenshot of PowerBI vs Excel:
Solved! Go to Solution.
@Anonymous , in excel is it Avg of Avg or Avg of line level
If you have used a measure = Average(Table[Return Time])
then you will get Simple Avg of like at row and grand total level
Now to Avg or Avg at the Grand Total level you can have measures like
Averagex(Values(Table[ticket Volumn]) , calculate(Average(Table[Return Time])
You can use visual grouping column in place of Ticket Volumn
@Anonymous , in excel is it Avg of Avg or Avg of line level
If you have used a measure = Average(Table[Return Time])
then you will get Simple Avg of like at row and grand total level
Now to Avg or Avg at the Grand Total level you can have measures like
Averagex(Values(Table[ticket Volumn]) , calculate(Average(Table[Return Time])
You can use visual grouping column in place of Ticket Volumn
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |