Create A SUMMARIZE Table using data from separate tables

[DebbieE]

I have the following model

And in order to do a  Key influencer visual over lots of data  in all the tables I want to create a SUMMARIZE Table and use related for the following

Behaviour, Attitude in behaviour and Attitudes table

event title and led by in Dim Events

stakeholder name from stakeholder and 

Theme from theme

It appears that Related isnt working for me. i was trying something like this

Key Influencer data =

var combinetable = ADDCOLUMNS( RELATED)

return

SUMMARIZE(combinetable,)

can someone provide me with the correct DAX for this. also will RELATED be ok if the middle fact table means that these tables arent directly related? (See the model)

[PaulDBrown · Accepted solution]

@DebbieE 

I'm not sure if this is what you are after, but you can create a SUMMARIZE table including related dimensions by establishing the fact table as the table reference in SUMMARIZE. For example, in this model:

If I want to create a SUMMARIZED table including the rows from the dimension tables I would use:

Summarize table =
SUMMARIZE (
    Sales,
    'DIM Channel'[Channel],
    'DIM Item'[Item],
    'DIM Product Ref'[Product REF]
)

[DebbieE]

thank you that worked perfectly. I didnt realise you could get around the issue by starting with the central fact table

[Anonymous]

Hi @DebbieE  Could you elaborate more on the query. I think what you want is to create a single table combining everything. 

Am I right?