Forum Discussion

kv's avatar
kv
Advocate I
6 years ago
Solved

DAX expression inside a PBI Role - Use string variable with delimited values for the IN clause value

Within a Power BI Role's DAX filter expression, is it possible to pass a local DAX variable that has a delimited string of values to an IN clause i.e [ColumnName] in  { "Event A", "Event B", "Event...
  • sturlaws's avatar
    sturlaws
    6 years ago

    Hi kv ,

     

    how about you change this

    CONCATENATEX (MyTable, [ProgramName], ",")

     

    to this

    SUMMARIZE(MyTable, [ProgramName])

    and drop the curly brackets

     

    Cheers,
    Sturla

     

     

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi kv ,

 

how about you change this

CONCATENATEX (MyTable, [ProgramName], ",")

 

to this

SUMMARIZE(MyTable, [ProgramName])

and drop the curly brackets

 

Cheers,
Sturla

 

 

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

  • kv's avatar
    kv
    Advocate I
    6 years ago

    That's brilliant sturlaws  Thank you. :)