Forum Discussion
Syndicate_Admin
3 years agoAdministrator
Cross-table filter
Good morning I have two tables: - One of them contains a single column with names (namesT) - The other table (data) has more data and among them a column with more than one name per column (nam...
- Anonymous3 years ago
Hi Syndicate_Admin ,
I suggest you to Split Column in Power Query Editor.
My Sample:
I add an index column and then split [NameT] column by comma,
I suggest you to remove or inactive the relationship between two tables.
Filter Measure = VAR _SELECTVALUE = VALUES ( 'Table'[NameT] ) VAR _Counttable1 = COUNTROWS ( _SELECTVALUE ) VAR _Counttable2 = CALCULATE ( COUNTROWS ( 'Table (2)' ), FILTER ( 'Table (2)', [NameT] IN _SELECTVALUE ) ) RETURN IF ( _Counttable1 = _Counttable2, 1, 0 )Add this measure into visual level filter and set it to show items when value =1.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Alex_Serebr
3 years agoFrequent Visitor
It should work if you create relationship between tables (namesT and data)