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.
Hello everyone!
I am trying to Sum Qty from two different data sources. The data sources both contain a column that has customer names.
So i am trying to sum the Overall Qty per customer.
Here i have an example. I tried using the quick messure to add qty on qty but that only worked overall not for individual customers.
Solved! Go to Solution.
Hi,
Please try to create a distinct dimension table and create relationships among them:
DimensionTable = DISTINCT(SELECTCOLUMNS('Test-1',"CustomerID",'Test-1'[CustomerID]))
Then create a measure to sum all Qty from two tables:
Measure = SUM('Test-1'[Qty])+SUM('Test-2'[Qty])
Choose [CustomerID] from DimensionTable and this measure as a table visual, it shows:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
Please try to create a distinct dimension table and create relationships among them:
DimensionTable = DISTINCT(SELECTCOLUMNS('Test-1',"CustomerID",'Test-1'[CustomerID]))
Then create a measure to sum all Qty from two tables:
Measure = SUM('Test-1'[Qty])+SUM('Test-2'[Qty])
Choose [CustomerID] from DimensionTable and this measure as a table visual, it shows:
Hope this helps.
Best Regards,
Giotto Zhi
Create a common dimension and join both tables with that.
You can create like
customer = distinct(union(all(table1[customer ]),all(table2[customer ])))
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 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |