Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filters / slicers not filtering eachother

Hi, 

I have build a report and there are two filters, one is "boardmember" and the second one is 

"owner". Now I want when filtered on a boardmember that only the owners with a value will show up. 

For example: 

Boardmember a  = Owner 1, 2, 3 

Boardmember b  = owner 5, 6, 7

Boardmember c  = Owner 8, 9, 10

 

So if I filter on boardmember a, only owners 1, 2, 3 should show in the filter. 

 

A bit like explained here: https://www.youtube.com/watch?v=o8K4Px_6AYQ 

 

But now I have both fields in the same table so option one isn't available. 

And I can't make a certain value like "amount complaints" of claims because it is filtering multiple graphs with different values.

 

Thanks in advance

 

Need Help
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous So your slicers are coming from the "blocked/shaded" tables? 
    your tables have many to many relationships which must be avoided. You need to create dimension or "bridge" tables with unique values linked to your fact tables in one to many relationships to use as your slicers 
    once you have done that, create a measure to filter the slicers based on the selection made in the other. Use:

    Filter slicers = COUNTROWS(RELATEDTABLE(Fact Table))

     

    select each slicer visual and add this measure to the filter pane for each slicer and set the value to "Greater or equal to" 1.

     

5 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous So your slicers are coming from the "blocked/shaded" tables? 
    your tables have many to many relationships which must be avoided. You need to create dimension or "bridge" tables with unique values linked to your fact tables in one to many relationships to use as your slicers 
    once you have done that, create a measure to filter the slicers based on the selection made in the other. Use:

    Filter slicers = COUNTROWS(RELATEDTABLE(Fact Table))

     

    select each slicer visual and add this measure to the filter pane for each slicer and set the value to "Greater or equal to" 1.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you! 

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous 

    Please show a depiction of the model with the tables you are using as slicers and the fact table

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Sorry for the confusing,

      The fields I want to filter on (board member and owner) are both in the same table, that is the fact table. Further I have a table for datefields (which i dont use in these two filters).

       

      Let me know if you still need the model.

       

      Thanks again for your help