79157349

Date: 2024-11-05 00:29:21
Score: 1
Natty:
Report link

you can create a dim table

Table = DISTINCT(Table1[Commodity])

create relationships among 4 tables. enter image description here

then use the commodity column in the new dim table as a filter and create two measures

table1 sum = sum(Table1[MTMValue])+0
table2 sum = sum(Table2[MTMValue])+0

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
Posted by: Ryan