incorrect syntax for 'in'

[ydundar]

Hey guys,

I am getting data from analyses services to create power bi report. But sometimes  I need to create measure based on user selelected values in report side. To getting sales data of selected months I am using below dax query. But it doesn't work. It gives incorrect syntax error. Because of some reason I can not create relationship with Month table and factSalesAmount table. Thanks in advance.

The query is:

SelectedMonthsSalesAverage = CALCULATE(SUM(factSalesAmount[CIRO]), FILTER(factSalesAmount, MONTH(factSalesAmount[TARIH]) IN VALUES(Months[Month]) ))