Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 55 | |
| 42 | |
| 41 | |
| 23 |
| User | Count |
|---|---|
| 166 | |
| 135 | |
| 120 | |
| 79 | |
| 53 |