Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 |
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 |
Try this:
WEIGHT = CALCULATE(SUM(Table2[VALUE]),FILTER(Table2,Table2[ID]=Table1[ID]))