DAX HELP!!

[kcjeongzz]

Hello guys,

I want to determine if the Width Value from the left chart is between Width and Width2 from the right chart for every row.

For example, I want the DAX to be expressed in this way so I can calculate the total percentage later.

12.13	X
12.13	X
12.12	X
12.11	X
12.1	O
12.1	O
12.1	O
12.09	O
12.08	O
12.08	O

Any help, please?

Thank you 

[harslan66]

You can use something like this:

Mold SIze = IF(AND(Table2[Width Value]>=12.40,Table2[Width Value]<=12.40),"No 0",
IF(AND(Table2[Width Value]>=11.90,Table2[Width Value]<=12.10),"No 1",
IF(AND(Table2[Width Value]>=11.00,Table2[Width Value]<=11.10),"No 2","NA")))

[kcjeongzz]

Thank you so much !

but the problem is there are more mold sizes ( a dozen more)

so it has to be dynamic TT