Forum Discussion
Helper IIICreate a DAX Summary table with data from Multiple tables
I would like to create a Summary table with pulling division from Divisions table and sum of Score from Delivery and Inventory Accuracy table
Division from Delivery and Inventory Accuracy are linked to Divisions table.
Can you please help?
lotus22 add a measure, and use this in the visual instead of columns, change column name and table name as per your model.
Total Score = SUM ( Table1[Score] ) + SUM ( Table2[Score] )✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
5 Replies
- parry2k
Super User
lotus22 not sure why you need a table but the following will do, change table and column name as per your mdoel.
New Table = SUMMARIZE ( Divisions, Divisions[Divison], "Sum", SUM ( AccuracyTable[ScoreColumn] ) )✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- parry2k
lotus22 since you already have one to many relationships with the Divisions table which is great, just use a matrix or table visual, put Division column from Divisions table and Score from the respective table and it will work.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- parry2k
lotus22 add a measure, and use this in the visual instead of columns, change column name and table name as per your model.
Total Score = SUM ( Table1[Score] ) + SUM ( Table2[Score] )✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
