Forum Discussion
Please help. Revenue per sqm
Hi all, I have a set of stores which I use as a mapping key. These set of stores will be filtered into either Tier 1 or Tier 2 stores. I have the revenue of each store by month and the size of e...
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.
Thanks smoupre, works like a charm. Dont know why I can't accept your response as a solution but I'll mark it once I get home with my home computer!
- Greg_Deckler
Community Champion
Awesome! Glad we got there!!