Forum Discussion

marsclone's avatar
marsclone
Helper IV
6 years ago

Measure not affected by filter

Hello,   I have a measure that calculates the correct value, but i do not want to change that value if a filter is selected. Which adjustments do i have to make in this measure?   Bedrag % = DI...
Need Help
marsclone's avatar
marsclone
Helper IV
6 years ago

Problem is that i have certain filters on page level. I want to keep them. 
in this measure the filter on "vervaltermijn" must not affect the outcome. 

parry2k's avatar
parry2k
Super User
6 years ago

marsclone 

ALL( Table[vervaltermijn])

 

not sure how your tables are related and what not.

 

 

 

 

  • marsclone's avatar
    marsclone
    Helper IV
    6 years ago

     

    parry2k 

     

    I've made a testfile, i really think there is a simple solution? But i can't find it.

    Thank you for your help!

     

    test 

     

     

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      marsclone my mistake it should be allexcept

       

      ALLEXCEPT( Table, Table[vervaltermijn])

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

      ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

       

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      6 years ago

      Hi marsclone 

       

      If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!