Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter specific numbers

Hey Guys,

try to sove this problem: I have a table with  numbers, which are categorised in versions (for example years: 2020,2019,etc.) and in species (for example Model 1,2,3...). I want a measure which shows me the numbers for version 1 filtered only by the species, which are in version 2. For example in version2 there are models 1&2 and i want my numbers for version 1 filtered after the model 1&2. But the measure has to be dynamic, because the models in the versions differ. Any ideas for a measure?

 

Thank You

Need Help

2 Replies

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

    Use ALLEXCEPT Function I think it solve the issue and for more clarification post dumy data and desire result 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Please provide some data and desired output for more imformation.

    Best Regards

    Community Support Team _ polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.