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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI blytonpereira,

 

It will be help if you provide some details information.

 

In my opinion, I'd like to suggest you create a variable table to add new column to expression table to store value from another table based on relationship.  Then you can simply to summarize and calculate on variable table.

 

For example:

Measure =
VAR summary =
    SUMMARIZE (
        ADDCOLUMNS ( Table1, "T2Col", RELATED ( Table2[Column2] ) ),
        Table[Column],
        [T2Col]
    )
RETURN
    SUMX ( summary, [Measure2] )

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi  

 

Im trying to use the measure to distinct count records in my data but it doesnt work.

 

I have 3 tables: 

 

Date Table --> Summarized by Month

 

Card Type Name --> Counted by Card Type Name

 

Station Sales Prepaid [ Account Number] -- > Field to be counted