Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

display multiple elements with SELECTEDVALUE (OR)

Hello,

 

I am using the DAX measure SELECTEDVALUE to display the value of a column that is filtered in a table visual.

But I can't find a way to display multiple elements.

 

For instance, if "France" is selected in the field 'Data'[Nationality], the DAXmeasure SELECTEDVALUE will display "France", and that is good. (SelectedNationality = SELECTEDVALUE(data[Nationality])

But if I select "France" and "Italy" in this filed, I would like that my measure displays both "France" OR "Italy".

 

Any idea HOW ?

Best regards,

Martin

4 Replies

  • Hi,

    Does this measure work?

    Measure = CONCATENATEX(VALUES(Data[Nationality]),Data[Nationality]," OR ")

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable

    None of them worked 😞