How to lookupvalue two different categories

Hi, Gokan 

According to your description in the first reply, you can try this calculated table to write the result in table X:

table X =

var _filter1=

FILTER('Sonuçlar',[Rep]="John Doe"&&[Month]="Jan"&&[Perf. Crit.]="Gelişim Index"&&[Value]<1)

var _filter2=

FILTER('Sonuçlar',[Rep]="John Doe"&&[Month]="Jan"&&[Perf. Crit.]="Pazar Index"&&[Value]<0.8)

return

UNION(_filter1,_filter2)

And you can get what the table like this:

For the formula in your second reply, I think it don’t have any problem. It’s a good solution.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.