My data model consists of 2 data tables that have 2 identicle columns to identify row values based on COMPANY and INDUSTRY
I've create a slicer/filter table that joins the unique combinations of these 2 columns between the 2 data tables
Programme and Company Slicer = UNION( SUMMARIZE( 'Materials Data' , [Industry] , [Company] ), SUMMARIZE( 'Social Index Data' , [Industry] , [Company] ))
Industry Company | A | Company T |
| A | Company F |
| A | Company G |
| A | Company C |
| A | Company G |
| B | Company A |
| B | Company T |
| C | Company A |
| D | Company I |
| D | Company D |
| D | Company E |
| D | Company F |
| E | Company A |
| F | Company F |
There is sometimes some overlap as these Companies may offer products/services for different formal industries/sectors.
When I've connected this Slicer Table to the 2 Data Tables, I've run into some issues. Not sure which relationship is right - I've chosen Many-to-Many and this works for one of the columns when I use the slicer, but not the other.
Please provide guidance on how to create a slicer that works with a tab. Slicer should have the Hierarchy INDUSTRY -> COMPANY
