Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago
Solved

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('T...
  • stribor45's avatar
    stribor45
    2 years ago

    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's avatar
tamerj1
Community Champion
2 years ago

stribor45 

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

stribor45's avatar
stribor45
Post Prodigy
2 years ago

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