Using Multiple value Parameters in DAX query

[shzaidi]

How to use multiple value parameter in dax query. I am creating dataset for my cascading dropdown. For single value following query is working 

EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] = @Division
))

but I need to use it for multiple values selected in Division which is not working

EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] IN (@Division)
))

Any idea or help will be appreciated.

[amitchandak]

@shzaidi , try like

EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] IN { @Division}
))

or

EVALUATE
UNION (ROW("Sector","All"),
CALCULATETABLE(
DISTINCT('Rollup'[SectorName]),
'Rollup'[DivisionName] IN @Division
))

[shzaidi]

The first suggestion syntax is correct but results are not. Selecting only one division it shows its sectors but selecting two or more divisions no sectors show up.

[amitchandak]

@shzaidi check if values or allselected works

'Rollup'[DivisionName] IN values( @Division)

'Rollup'[DivisionName] IN allselected( @Division)

[shzaidi]

Both has syntax errors, not accepting parameter value as table values even multiple values check in parameter is on.