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 ot...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi abertolett,

 

Based on your description, I have created sample data about Table A and Table B (See attached .pbix file), you can try the measure below:

 

Revenue/Orders = DIVIDE(CALCULATE(SUM('Table B'[Revenue]), FILTER(ALL('Table B'),'Table B'[Item] = MAX('Table A'[Item]))),CALCULATE(SUM('Table B'[Orders]), FILTER(ALL('Table B'),'Table B'[Item] = MAX('Table A'[Item]))))

 

Best Regards,
Qiuyun Yu