Forum Discussion
Adjust Filter function
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"
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")
4 Replies
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
