Adjust Filter function

[stribor45]

I am trying to adjust my filter function but it might be related to an error because I am filtering based on different related tables.  

FILTER ( 'Table A, 'Table A'[Name] <> "John" && RELATED('Table A'[Call Time]) = "Evening")

Table A is related to my Calendar Time in many to one relationship and this is what it looks like (see below). Is there a way to write DAX that picks up all rows whose name is not JOHN and whose related table (Calendar time table ) has Evening column set to "Evening"

[stribor45]

The column Table A [Call Time] either doesn't exists or doesn't have relationship to any table available in the current content. 

table A has many to one relationship with Calendar Time table

[tamerj1]

@stribor45 

In the screenshot it is called "Evening" which one is correct?

[stribor45 · Accepted solution]

sorry i think I need coffee badly 🙂

fixed it...this is my bad

FILTER ( 'Table A', 'Table A'[Name] <> "John" && RELATED('Calendar Times'[Evening]) = "Evening")

[tamerj1]

@stribor45 

Your filter is correct. What error are you receiving?