cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Microsoft

## dax to get a list of values

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!

2 ACCEPTED SOLUTIONS
Solution Sage

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
Community Champion

@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.

Proud to be a Super User!

9 REPLIES 9
Community Champion

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

Proud to be a Super User!

Microsoft

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

Community Champion

@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.

Proud to be a Super User!

Helper I

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

BI Analyst and Developer @ Queen Mary University of London, UK.
Microsoft

@KHorsemanyou're right

thanks!

Microsoft

@KHorseman

hi again,

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

the order is incosistent.

thanks!

Community Champion

@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.

Proud to be a Super User!

Solution Sage

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
Solution Sage

/sdjensen

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors