How to aggregate Data on Order+Article Level to Order Level?

[Anonymous]

Hi Power BI community,

I was trying to aggregate Data on Order+Article level to Order level on Power BI Desktop but it keeps crashing.

Basically I have a massive database (24 million records) in Order+Article level with metrics like Net Sales and Discounts and want to aggregate it in Order level (8 million distinct orders) and have the metrics in that level. An Order has multiple Articles.

Do you know any way of being able to achieve this? Thank you so much

A quick example

As-is (24 million records)

Order ID	Article ID	Net Sales	Discounts
1	A	5	-3
1	B	3	-1
1	C	7	-2
2	A	4	-2
2	C	6	-3

To-be (8 million records)

Order ID	Net Sales	Discounts
1	15	-6
2	10	-5

[lbendlin · Accepted solution]

Power BI does that automatically for you. All you need to do is not include the [Article ID]  column in the visual.