Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer to filter third table single direction

Hi everyone,   This is my dilemma 😞   I have three tables A, B, C Table A is filtering B (single direction relation), and table C is filtering B as well (single direction) I have a visual that...
Need Help
Show and Tell
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    Create a new measure along the lines of:

    Filter Slicers = 

    COUNTROWS(RELATEDTABLE (Table B))

     

    now add this measure to the filter pane for each slicer and set the value to greater or equal to 1

    Slicer A will now filter slicer C and viceversa

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Create a new measure along the lines of:

Filter Slicers = 

COUNTROWS(RELATEDTABLE (Table B))

 

now add this measure to the filter pane for each slicer and set the value to greater or equal to 1

Slicer A will now filter slicer C and viceversa