Forum Discussion
Solved
Filter over 2 tables
Hello, I have two tables that aren't linked to each other. In the first table (blue), the value is selected using a filter visual. All "CP IDs" should then be displayed where the filter condition is ...
Hi stefantaust
I understand you want to filter the second table (Phase ID) based on selections in the first table (blue filter visual) without creating relationship between tables, am I right? Then try:
FilteredCPIDs = VAR SelectedCP = SELECTEDVALUE(FirstTable[CP ID]) RETURN IF( ISFILTERED(FirstTable[CP ID]), CONCATENATEX( FILTER('Phase ID', 'Phase ID'[CP ID] = SelectedCP), 'Phase ID'[CP ID], ", " ), "Select a CP ID" )
Hi stefantaust ,
if you really want the blue table as slicer, make an union table. That will solve the purpose.