cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION
Super User

@Anonymous ,

Try like

``AverageX(Summarize(Table,Table[Order], "_1",sum(Table[Q])),[_1])``
Super User

@Anonymous ,

Try like

``AverageX(Summarize(Table,Table[Order], "_1",sum(Table[Q])),[_1])``

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.