Forum Discussion

lotus22's avatar
lotus22
Icon for Helper III rankHelper III
4 years ago
Solved

Create 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 lin...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

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.⚡

lotus22's avatar
lotus22
Icon for Helper III rankHelper III
4 years ago

HI parry2k , Thank you for quick reply. I need to add up the score for the Division from Delivery and Inventory Accuracy, put it on a Table or Matrix Visual. How can I do this without creating a summary table.

  • lotus22's avatar
    lotus22
    Icon for Helper III rankHelper III
    4 years ago

    parry2k Scores show up as two columns. I want to add them up, and that is how we score our divisions. There should be only one Score column.