Get measure value from unrelated table

[NDDD]

Good day all, 

  Have a question, how I can add measure from unrelated table. Both tables have same column: sum of week number.  I tried to connect by sum of week number column but since there are many entries per week they are not unique. In both $ column values are measures. 

Exs 

Table 1 

sum of week number	$
1619	$           2,750,918
1620	$           8,343,011
1621	$         14,347,203
1622	$         20,888,949
1623	$         28,001,553
1624	$         35,592,918
1625	$         41,199,415
1626	$         47,592,132

Table 2

sum of week number	$
1619	$         3,390,265
1620	$         7,268,534
1621	$       11,194,207
1622	$       15,058,229
1623	$       19,671,375
1624	$       23,832,094
1625	$       27,540,713
1626	$       31,916,306

Thank you

[NDDD]

@v-yinliw-msft  Thank you the replay, it didn't work. I'm trying to create clustered column chart using the 2 measures plus I didn't mentioned I need the ration between the two measures. When I follow your suggestion if I add column from a date table newly measure is blank. My measure are calculation last 13 weeks of $ in both cases but there is no way to connect the tables as there are multiple $ entries on daily basis. 

Thank you

[v-yinliw-msft]

Hi @NDDD ,

In table1:

Measure1 = SUM(Table1[ $]) 

In table2:

Measure2 = SUM(Table2[ $])

Measure = [Measure1]

 Just use the measure normally.

Could you please tell me what kind of calculation do you want to do?

Hope this helps you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.