Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to Solution.
Check out my Super Group design pattern, I think it may help:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
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
Check out my Super Group design pattern, I think it may help:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |