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 two tables - Sales and Production which store total units sold and produced by time period. I am trying to show total units from the two tables under one column, but becuase the values from two tables, I get two table headers in the matrix view:
I would like the result under one column as Total EUs and have production units from produciton table and sales units from sales table. Like:
Department | Total Eus |
Production | 28649409 |
Sales | 28735616 |
Please advise.
Solved! Go to Solution.
Create a measure that adds both values, and display the measure.
Create a measure that adds both values, and display the measure.
I was able to create a new table with keys for Sales and Production and create a relationship between the new table and the individual data tables. After that, the new measure for the total sum worked with differentiaiton for each key.
How will it differentiate the sum between sales and production?
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |