Forum Discussion

blytonpereira's avatar
blytonpereira
Icon for Helper II rankHelper II
7 years ago

Summarize over columns from Different Tables

Hello   I would like to use the SUMX function with Summarize over columns from different tables.   I have a table named "Region" with a single column also named "Region". I have a second table n...
Need Help
AkhilAshok's avatar
AkhilAshok
Icon for Solution Sage rankSolution Sage
7 years ago

Does these 2 tables, Region and P2, relate to a common fact table? If yes, then you have to SUMMARIZE over the common fact table to which these 2 tables are linked to:

 

Measure =
SUMX ( SUMMARIZE ( Fact, Region[Region], P2[P2] ), [Measure] )