topic Re: Adjust Filter function in DAX Commands and Tips

Adjust Filter function

stribor45 — Thu, 05 Oct 2023 17:07:04 GMT

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"

Re: Adjust Filter function

tamerj1 — Thu, 05 Oct 2023 17:56:14 GMT

stribor45

Your filter is correct. What error are you receiving?

Re: Adjust Filter function

stribor45 — Thu, 05 Oct 2023 18:06:31 GMT

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

Re: Adjust Filter function

tamerj1 — Thu, 05 Oct 2023 18:37:10 GMT

stribor45

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

Re: Adjust Filter function

stribor45 — Thu, 05 Oct 2023 19:30:59 GMT

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")