Forum Discussion

kivancc94's avatar
kivancc94
Helper I
3 years ago

Different Filters Coming from Same Data Source

Hi everyone,

i would be appreciated if you could help me. My problem is that I would like to create 3 different "Filters" affecting 3 different "Cards" BUT filtering datas are coming from same data sources. So when i make a selection in 1st filter, it also changes the 2nd and 3rd filter selections. I want them to be independent from each other. "EDIT INTERACTION" did not work for this issue. 

 

 --> Filters are coming from same data source. And content of filters is like below includes working hours.


--> Production targets are measures. Like below;

Production Target (Saturday) = COALESCE(Performans[Performans Value]*SELECTEDVALUE('Shift'[Working Hours]),0)




THE PROBLEM is you can see an example below,

When i filter 1st filter it also affects other filters. What i wanna achieve is " 1 must filter a  & 2 must filter b & 3 must filter c" 



Best regards
kivancc94





 

Need Help
Show and Tell
Tips and Tricks

4 Replies

    • kivancc94's avatar
      kivancc94
      Helper I
      3 years ago

      Thanks a lot, it worked. 

      But i faced different problem now. I tried to achieve TOTAL by using this formula ;

      TOTAL = [Production Target ( Workdays )] + [Production Target (Saturday)] + [Production Target (Sunday)]


      Gives me 0. Didnt make any sense for me, how could it be possible not being affected by the filter and formula ?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi kivancc94  can you provide sample dataset?