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.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors