Forum Discussion

kivancc94's avatar
kivancc94
Icon for Helper I rankHelper 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 dat...
Need Help
Show and Tell
Tips and Tricks
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

kivancc94 

Hello kivancc94  idk why you side "EDIT INTERACTION" did not work, i also try with "EDIT INTERACTION" it's working fine.

 

kivancc94's avatar
kivancc94
Icon for Helper I rankHelper 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? 

    • kivancc94's avatar
      kivancc94
      Icon for Helper I rankHelper I
      3 years ago

      Hi, 

      Sorry for the language which is not English. You can find dataset below.

      Shift datas are received from "Shift" table;

       


      Production target measures are received from "SPR" table.

      Production Target ( Workdays ) = COALESCE(Performans[Performans Value]*SELECTEDVALUE('Shift'[Working hours])*(5-'Holidays'[Parameter Value]),0)

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

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