Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table that is created by a UNION of several other tables.
The UNION of several tables effectively counts recordIDs. Here's the code creating that table:
One of the fields in the 'Campaign Sourced & Influenced' table is 'Amount'. I'd like to SUM amount for only one of the columns, the related 'Campaign Sourced and Influenced OTY'.
Using the field 'Amount' and summing it as a value almost works except the SUM appears with every Column generated by the UNION table.
How can I SUM the 'Amount' for only one column, Campaign Sourced and Influenced OTY' and put it next to that column?
Solved it another way.
Take a step back and question if the UNION method makes sense? (it doesn't - theres a much easier way)
Since the table is related in the model, simply create quick measures and drop them into the values.
Here's the output.
Have you considered doing the Sum before you do the union.
You would have to create a dummy field in the tables in the union that do not show the sum.
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |