Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Basic Question on DAX Model

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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.