criteria var - ID PRODUCT

[vierarc1234]

Hello everybody,
I have an order base and in this a “Product ID” can occur in the 3 situations "In", "Out" or "Both" in a machine.

I wanted to create a variable according to the “Criteria Used” table to show in each “Product ID” which class "In", "Out" or "Both" it fits.
Doing it through the Visual Matrix, I can see the manual by different entries, where the entire column refers to the criterion “B” because there has already been an order in condition “I” and “O”.

can anybody help me?
Thank you very much.

[tamerj1 · Accepted solution]

Hi @vierarc1234 

please try

ID Result =
IF (
HASONEVALUE ( 'Table'[Type] ),
IF ( VALUES ( 'Table'[Type] ) = "In Machine", "In", "Out" ),
"Both"
)