incorrect syntax for 'in'

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

Forum Discussion

incorrect syntax for 'in'

Related content

Microsoft SQL: Incorrect syntax near the keyword 'exec'. Incorrect syntax near ')'.

Power BI - The syntax for ')' is incorrect

The syntax for ')' is incorrect

The syntax for 'Level' is incorrect.

SQL Query Syntax issue