Forum Discussion

PowerKoen's avatar
PowerKoen
Frequent Visitor
7 years ago

Filtering table on different colomns

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?

Need Help

2 Replies

    • PowerKoen's avatar
      PowerKoen
      Frequent Visitor
      7 years ago

      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?