Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SUMMARIZE using column from another table

Hi,   I am trying to summarize a table across Regions and Categories for the amont of Spend, but then I also want to add another column to the grouping for the 'Asset' which comes from a table link...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    If that other table with Asset column is on the side of the relationship, then you can simply add it as GROUPING Column

     

    =
SUMMARIZE (
    'Visibility Data - All Regions',
    'Visibility Data - All Regions'[Region],
    'Visibility Data - All Regions'[Group],
    'Visibility Data - All Regions'[Category],
    'Visibility Data - All Regions'[Sub Category],
    OtherTableName[AssetColumn],
    "Revised Spend (USD)", SUM ( 'Visibility Data - All Regions'[Revised Spend (USD)] )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-jiascu-msft,

 

Ah, I actually cleaned up my data model yesterday as I was previously using the new Many-to-Many relationship option for just one of the tables (the one I needed to get the extra column from!).

 

Trying the same code Zubair_Muhammad suggested yeterday has worked perfectly! Is there a reason why this won't work on the MANY side?

 

Thank you both for you help.

 

TG

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

As we can see from the definition on this site, SUMMARIZE returns totals over a set of groups. So what can we expect the totals of one-side from the many-side? 

I'm glad you solved the issue.

 

 

Best Regards,
Dale