Calculated column / measure for sankey diagram

[laciodrom_80]

I've got these two tables:

Table1 columns

ID - WEIGHT - SOURCE - DESTINATION

Table2 columns

Column: ID - DATE - VALUE

The two tables are linked by ID column, I would to have a sankey diagram which uses columns in Table1, but WEIGHT should be a calculated one (or a measure) computed summing all matching (by ID) values in column VALUE of Table2. Then using a slicer by DATE column I would like to filter sankey diagram by date.

I've tried this calculated column  WEIGHT = Sum('Table2'[VALUE]) but it doesn't work well   

How should I rightly calculate WEIGHT column (also using a measure) ?    

Thanks a lot for any hint

[Thejeswar · Accepted solution]

Hi @laciodrom_80,

Just create a measure using the following DAX

Weight Measure = SUM(Table2[Value]) 

 

The Following are the tables' data. For your reference

Table1

ID	Weight	Source	Destination
1	0.5	DestA	DestB
2	1.2	DestB	DestA
3	2.5	DestC	DestB

Table2

ID	Date	Value
1	1/1/2018	20
2	5/2/2018	25
3	4/3/2018	30

[Anonymous]

Try this:

WEIGHT = CALCULATE(SUM(Table2[VALUE]),FILTER(Table2,Table2[ID]=Table1[ID]))