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.
A jan 1000 500
A feb 1000 700
B jan 2000 600
B feb 2000 800
C jan 2500 1000
C feb 2500 900
Size never changes across months, but revenue will.
I have relationships on the store which will group them in my pivot, so for example A and B will be tier 1 location, so I need the average to kind of "average" the unique store sizes then Sum the sizes of each unique store.
Thanks!!
- Greg_Deckler
Community Champion
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.
- Ashish_Mathur
Super User
Hi,
Your question is not clear. Based on the data you share, show the expected result.
