why is this not a valid table

[bsheffer]

I'm trying to use this variable in an IN statement in a calculate

var _months_selected = calculate(VALUES('Dim Calendar ActivityMonth'[MonthNo]), allselected('Dim Calendar ActivityMonth'))

but when I use it in this clause it says it isn't a valid table

month('Dim Calendar ActivityMonth'[Date]) in _months_selected

what's the correct syntax?

[jeroendekk · Accepted solution]

Hi @bsheffer 
If you want to create a table you should use CALCULATETABLE not CALCULATE.

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Best regards,

Jeroen