Calculated column / measure for sankey diagram

[laciodrom_80]

Hi guys,

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.

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

Hi guys,

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.

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

Thanks a lot for any hint

Hi guys,

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.

Hi guys,

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.

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

Thanks a lot for any hint

Hi guys,

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.

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

Thanks a lot for any hint

Hi guys,

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.

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

Thanks a lot for any hint

Hi guys,

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

[v-frfei-msft · Accepted solution]

Hi @laciodrom_80,

I made one sample for your reference, if it doesn't meet your requirement, kindly share your sample data anc excepetd result to me.

Create a measure.

Measure = CALCULATE(SUM(Table1[WEIGHT]))

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @laciodrom_80,

Does that make sense? If so, kindly mark the answer as solution to close the case.

Regards,
Frank