Filter syntax not working for me

[BenDonahue]

I am trying to run a filter for a data table:

Filter(HouseholdInteractionSurveyData, DoorAnswer = DoorAnswerDD.Selected.Value) ( .Result is not an option)
I am drawing off of a SP list, HouseholdInteractionSurveyData, that has a header, DoorAnswer.
I have a Dropdown called DoorAnswerDD.
I get a red underscore under the equal sign, "Invalid Argument Type."
DoorAnswer and DoorAnswerDD are both Control data types.
DoorAnswer was originally gathered via a dropdown

As I understand it, this shoudl work:
Filter(HouseholdInteractionSurveyData, DoorAnswer = DoorAnswerDD.Selected.Value)

or this, even:
Filter(HouseholdInteractionSurveyData, DoorAnswerDD.Selected.Value in "DoorAnswer")

however, I can't get either to work.

Your help is greatly appreciated.

[RandyHayes · Accepted solution]

@BenDonahue 

You did not mention the type of Column that DoorAnswer is in your datasource.  If it is a Choice column, then give the following formula a go:

Filter(HouseholdInteractionSurveyData, 
     DoorAnswer.Value = DoorAnswerDD.Selected.Value
)

If still an issue, then respond back with the type of column you have for DoorAnswer in your datasource.

I hope this is helpful for you. 

[BenDonahue]

For the record, and the community, yes, the column data type in my SharePoint list was, in fact, Choice. 

Randy, you beautiful person, that got it working like a charm. Much thanks to you, sir.