Exclude rows based on two columns and list values

[Yury]

Hello Experts ,

I need to exclude rows in the table based on two columns information. 

For example, I have a list of materials like 'A','X','Y','Z' and i need to exclude all invoices where this materials exist

For source below I need to exclude three first rows where invoice is 111 as it contain material from the list - 'A'

Invoice	Material
111	A
111	B
111	C
222	B
222	C
222	E

I'm really not good in set analysis, so, please help me to write down correct expression.

Thank you!

[Rodj]

Hi @Yury 

You can exclude sets by using the "-=" symbol in your set modifier, like so:

sum({$<Material -= {'A'}>} YourMeasure)

To do it for all values of Material as you appear to want to do:

sum({$<Material -= {"*"}>} YourMeasure)

You can also look to use the 'P()' and 'E()' element functions to do things like this.

Hopefully what you need is somewhere in there, I wasn't entirely clear on what you are trying to do.

Cheers,

Rod

[sunny_talwar · Accepted solution]

May be this set analysis within your expression

{<Invoice = e({<Material = {'A','X','Y','Z'}>})>}