Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
dear all,
I have the following table:
Order | Orderline | Q |
A | 1 | 1000 |
A | 2 | 500 |
A | 3 | 10000 |
B | 1 | 5000 |
B | 2 | 2500 |
C | 1 | 400 |
C | 2 | 200 |
C | 3 | 600 |
C | 4 | 600 |
average = | 2311,1 |
The average of the lines is 2311, but i want an order average, which would look like this, with the following outcome:
Order | Orderline | Q | Order Q |
A | 1 | 1000 | 16500 |
A | 2 | 500 | |
A | 3 | 10000 | |
B | 1 | 5000 | 7500 |
B | 2 | 2500 | |
C | 1 | 400 | 1800 |
C | 2 | 200 | |
C | 3 | 600 | |
C | 4 | 600 | |
average = | 2311,1 | 8600 |
So where all the Q's are summed together, and then taken the average, so you know the average Q per order.
Solved! Go to Solution.
@Anonymous ,
Try like
AverageX(Summarize(Table,Table[Order], "_1",sum(Table[Q])),[_1])
@Anonymous ,
Try like
AverageX(Summarize(Table,Table[Order], "_1",sum(Table[Q])),[_1])
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |