This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 28 | |
| 23 | |
| 22 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 61 | |
| 35 | |
| 29 | |
| 23 | |
| 22 |