Forum Discussion

Pillic's avatar
Pillic
Helper II
2 years ago
Solved

AND logic filter measure

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_IDMATNR
1A
1B
1C
1D
2A
2C
2D
3B
3D

 

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?

Need Help

4 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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??

     

     

     

  • Pillic's avatar
    Pillic
    Helper II
    2 years ago

    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,