Forum Discussion

abertolett's avatar
abertolett
Frequent Visitor
9 years ago
Solved

Aggregating after data is grouped/rolled-up

I have two tables joined one to many in power bi desktop.

 

So it does a good job automatically summing up numbers based on that field.

 

But I'm trying to roll-up an AVG which is based on two other columns. And it just keeps summing my averages.

 

Simplified model below. 

 

 

There is one "Widget A" record in Table A. There are multiple "Widget A" records in Table B which is where Revenue and Orders roll up. So "Item" is from Table A and "Revenue" and "Orders" are from Table B.

 

I simply want the *rolled up* Revenue and the *rolled up* Orders to be able to be calculated on to make a new AVG.

 

I'm probably missing something obvious...

2 Replies