AND logic filter measure

[Pillic]

Hi community,

I have a table that holds multiple SAMPLE_IDs that include multiple MATNR. Now I need an AND logic measure to get distinct SAMPLE_IDs when each selected MATNR is included.

SAMPLE_ID	MATNR
1	A
1	B
1	C
1	D
2	A
2	C
2	D
3	B
3	D

In this sample I want to use MATNR as slicer and if I select MATNR B and D the result should be:

SAMPLE_ID

1

3

How can this be achieved?

[ThxAlot · Accepted solution]

[Pillic]

ThxAton @ThxAlot ,

this is exactly, what I was looking for.

Great TY

[Pillic]

Hi @Uzi2019,

1 and 3 are the distinct SAMPLE_IDs which have the MATNR: B AND D included.

So when the selection of MATNR: B AND D is available in any SAMPLE_ID I need the distinct SAMPLE_IDs as result.

Thanks for having a look into this,

[Uzi2019]

Hi @Pillic 

Didnt get your expected answer logic. what represents 1 and 3 in your output??

if you see the input you have it has 2 B and 3 D right??

you want the count of sample Id??