Forum Discussion

paolomint's avatar
paolomint
Helper III
4 years ago
Solved

How to filter... a filter without using bidirectional option

Dear all,

Just to explain the problem, I create a very easy model:

 

If I filter by costumers, Items filter don't change:

 

How can I link those filters?  How can I  filter items by costumers (also the other way around: filter costumers by items) without using the bidiretional filter option?

 

Here you are the pbix file:

file https://www.dropbox.com/s/zoqkqi93bl9fdtj/ToAvoidBDFilter.pbix?dl=0

 

thanks in advance

Paolo

 

 

  • paolomint 

    You can create a measure like below: 

    SalesFilter = COUNTROWS(SALES)

     Then assign it to the visual filter of the slicer and set it to "Not is Blank"

     

2 Replies