Filter specific numbers

[Anonymous]

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

[Anonymous]

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.

[mh2587]

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