Forum Discussion

shzaidi's avatar
shzaidi
Helper I
5 years ago

Using Multiple value Parameters in DAX query

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.

 

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      shzaidi
      Helper I
      5 years ago

      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's avatar
        amitchandak
        Super User
        5 years ago

        shzaidi check if values or allselected works

         

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

         

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