Forum Discussion
Releationship
Aren't column 'RM Batch' of table A and column 'Batch Number' of table B the same type of data?
There are a same number '50157797'.
batch number in table B is combination of all types of batchs from table A
Wouldn't the problem be solved by unpivoting all batch number columns in table A?
For your reference.
Step 1: I unpivot 'Table-A'.
Step 2: I make a summarize table 'Batch Number Table'.
Batch Number Table = SUMMARIZE('Table-A','Table-A'[Batch Number])
Step 3: I add 2 relationships.
Step 4: I make 2 'Table' visuals.
Step 5: I click '50157797' of 'Table-A'.
Thanks for the response,but here we need slicers at top and we are using sankey chart for there relation of batches like Vendor>RM RM>bulk Blk>sfg,,,,as such