Forum Discussion
Please help. Revenue per sqm
Oh! You have a Groups/Super Groups problem on your hands. So in your size measure, you are going to need to use SUMMARIZE to get the AVERAGE of each individual store (which will give you the actual store size) in the group and then just use SUM to SUM the AVERAGE of the sizes. See this article:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Sorry, none of that made any sense until you mentioned your related table for grouping.
Community ChampionDoes the square meter of you store change every month? Because if you had data like:
Store,Revenue,SQM,Month,Year
Store1,$1000,10,1,2018
Store1,$2000,10,2,2018
If the square meters of the store is the same then if you take the average of it, you should get the square meters of the store regardless of how you aggregate. Or just use MAX or MIN? Need to see data.