cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DebbieE
Super User
Super User

Create A SUMMARIZE Table using data from separate tables

I have the following model

 

StakeholderSTAR.JPG

 

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)

 

 

1 ACCEPTED SOLUTION
PaulDBrown
Super User
Super User

@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:

Model.JPG

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]
)

 

 

Sum Table.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
PaulDBrown
Super User
Super User

@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:

Model.JPG

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]
)

 

 

Sum Table.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

Anonymous
Not applicable

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?

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors