Select with 2 Condition for dropdown

[codename-12]

i'm try to get data in depend drop down but i need to filter the conditions 

ANY(
AND(SELECT(Room_Data[ID_Room], ([_THISROW].[Room Type] = [Room_Type])),FILTER("Room_Data", [Status] = "VC"))
)

[TeeSee1 · Accepted solution]

FILTER("Room_Data", AND([Room_Type]=[_THISROW].[Room_Type], [Status]="VC"))

Some typos corrected..

[codename-12]

Thanks for the solutions