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 ,

Thank you for reaching out to the Microsoft Fabric Community, and we also appreciate the helpful insight already shared by Elena_Kalina  .

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.