Filtering table on different colomns

[PowerKoen]

Hi there,

I got the following situation:

RelationsTabel visual

On the "Filtered Field", I want a colomn that checks the following:

Filter if a row
Delivery[Fault number]= NOT BLANK

AND
Delivery[Fault Code] is the same as Problem Codes[Code]
Then
return the Problem Codes[Sales Assigned to]
IF value (of Sales Assigned to)=5 AS 1

I tried different filters and IF statements, but can't get it to work.

How can this be done?

[v-chuncz-msft]

@PowerKoen ,

You may try using CONTAINS, LOOKUPVALUE and RELATED.

[PowerKoen]

I tried the following:

IF(RELATED('Problem Codes'[Sales - Assigned to])=5 && 'Delivery'[Fault number]=BLANK();1;0)

It shows correctly in the table/data view :). 
But when i use it in a visual, its not showing the correct values only zero's (0).

What do i do wrong?