dax to get a list of values

[MP_123]

hi

i saw here a dynamic measure to show the value selected in the slicer

ifhasonevalue -> values()

is there any way to show more than one values? i mean, if i selected to items on slicer, to show both of them in dynamic measure

thanks! 

[sdjensen · Accepted solution]

Do you mean something like this? I know that some of my screenshot is in danish but I know you can understand anyway.

Here is some translations

År til dato (i går) = Year to date (yesterday)

Sidste år til dato (i går) = Previous year to date (yesterday)

Måned til dato (i går) = Month to date (yesterday)

Måned til dato (sidste år i går) = Month to date (previous year yesterday)

I går = Yesterday

I går (sidste år) = Yesterday (previous year)

[KHorseman]

Selected Stuff = CONCATENATEX( VALUES( TableName[ColumnUsedInSlicer]), TableName[ColumnUsedInSlicer], ", ")

[MP_123]

@KHorseman it's good but i think more than two (i don't know in advanced how many)

[KHorseman · Accepted solution]

@MP_123 if you're referring to the fact that CONCATENATE only takes two arguments to concatenate, that does not apply here. CONCATENATEX is not the same as CONCATENATE. This measure will concatenate a list of any arbitrary number of selected items in a slicer. Try it on your dataset.

[zaforir2002]

thanks for your post, however, I'm having wired issue, the CONCATENATEX function is greyed out in Power BI desktop, any idea?

[MP_123]

@KHorsemanyou're right

thanks!

[MP_123]

@KHorseman

hi again,

do you have an idea how to sort  the concatenatex alphabeticaly maybe with another dax function?

the order is incosistent.

thanks!

[KHorseman]

@MP_123 I don't think so. DAX functions that return tables or columns never guarantee their sort order as far as I can tell. The only way to get CONCATENATEX to concatenate in alphabetic order would be to pre-sort the column you're feeding into the first argument, where I used VALUES. I suppose if you could come up with a way to use RANKX to rank the words in alphabetic order you might be able to make it work, but I can't think of a way to do that either.

[sdjensen · Accepted solution]

Do you mean something like this? I know that some of my screenshot is in danish but I know you can understand anyway.

Here is some translations

År til dato (i går) = Year to date (yesterday)

Sidste år til dato (i går) = Previous year to date (yesterday)

Måned til dato (i går) = Month to date (yesterday)

Måned til dato (sidste år i går) = Month to date (previous year yesterday)

I går = Yesterday

I går (sidste år) = Yesterday (previous year)

[sdjensen]

You can read about how to create a similar dimension here