Forum Discussion
Cross-table filter
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.
A relationship already exists, and it doesn't work.
The contents of the T-names table would be as follows:
| Nerea |
| Pedro |
| Jaime |
| Silvia |
| Juan |
And the name cell of the data table would look like this:
| Juan,Silvia |
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 Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.