Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
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]
)
Proud to be a Super User!
Paul on Linkedin.
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]
)
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |