Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
I am fairly new to DAX and struggling with what I think is something quite basic that I am hoping somebody will be able to help with.
I am trying to create a new calculated column in my "Control results" table (Pleas see my model below) that just sums the values of both the "Metric Text Box Integrated with" Column and the "Multi Choice Button Interacted with" column from my "Metrics" table.
I am using the following Dax Formula
I am sure this is something very basic, but I would be very grateful of any help anyone can give.
Solved! Go to Solution.
@DLittle , You need two use one of the 4 way copy data from one table to another
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
related , relatedtable, lookup or sumx/minx/maxx with conditions
Thanks You @amitchandak I used the SUMX with a FILTER has it has worked perfectly
@DLittle , You need two use one of the 4 way copy data from one table to another
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
related , relatedtable, lookup or sumx/minx/maxx with conditions
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 28 | |
| 28 | |
| 19 | |
| 19 | |
| 19 |
| User | Count |
|---|---|
| 37 | |
| 29 | |
| 18 | |
| 17 | |
| 15 |