Forum Discussion

stefantaust's avatar
stefantaust
Icon for Helper I rankHelper I
1 year ago
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 ...
Need Help
  • Elena_Kalina's avatar
    Elena_Kalina
    1 year ago

    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"
)
Elena_Kalina's avatar
Elena_Kalina
Icon for Solution Sage rankSolution Sage
1 year ago

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"
)