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

Create two pre-filtered table versions (for "Only KAUF" and "Only FERT"), then follow the steps from the video to set up a toggle.

https://www.youtube.com/watch?v=5QMpc5fUV2I&t=97s

For your solution, you can also use radio buttons (like in the screenshots below) instead of a toggle.

 

 

stefantaust's avatar
stefantaust
Icon for Helper I rankHelper I
1 year ago

Hello, radio buttons aren't ideal. It would be better if I could filter using the blue list.

 

'Definition MM Data' [SOMA Profile]


I've created two prefiltered tables with only KAUF and only FERT:

FilterStatus ZPCO_KAUF_01 = CALCULATETABLE('Prozess Schritte', 'Prozess Schritte'[ZPCO_KAUF_01]="ZPCO_KAUF_01")

FilterStatus ZPCO_KAUF_01 = CALCULATETABLE('Prozess Schritte', 'Prozess Schritte'[ZPCO_KAUF_01]="ZPCO_FERT_01")

 
How can I solve it using the "blue" Visual filter, which only shows KAUF or FERT?

 

 

  • Elena_Kalina's avatar
    Elena_Kalina
    Icon for Solution Sage rankSolution Sage
    1 year ago

    Then my solution doesn’t suit you. When I suggested creating two filtered tables, I meant two visuals using the same underlying table. This would allow simulating a slicer using bookmarks. Apparently, you need these tables not just for display purposes after all