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"
)
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi stefantaust ,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.