Filters / slicers not filtering eachother

[Anonymous]

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

[PaulDBrown · Accepted solution]

@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]

Thank you! 

[PaulDBrown]

@Anonymous 

Yes please

[PaulDBrown]

@Anonymous 

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

[Anonymous]

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