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 2 Tables with Data as follows
TEST1
A 5
B 10
TEST2
A P1
A P2
A P3
B P4
B P5
I pulled all the Columns to a Table on Desktop and got below Results -
A P1 5
A P2 5
A P3 5
B P4 10
B P5 10
-------------
15
Total Row being 15 ... What I expected is to join TEST1 table with TEST2 and then sum the Numeric field but instead of the Total being 35 it is still 15. How does the DAX evaluate for this Scenario ???
Hi,
Using the Query Editor, you should first merge both Tables into one (joining based on the first column) and then write a simple measure
=SUM(Merged Table[Amount])
Hope this helps.
Hi Ashish,
I am just trying to understand how the DAX is computing a Total of 15 instead of 35 when you try to pull all the Columns from both the Tables.
Thanks Ashish & Phil for responding to this Topic.
Here is what I am visualizing in SQL World -
SELECT SUM(TEST1.Column2) FROM (SELECT * FROM TEST1 INNER JOIN TEST2 ON TEST1.Column1 = TEST2.Column1) A
But I think the SUM is still 15.
How have you created the bottom table? Have you just created a relationship between the two tables?
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |