Create a measure that shows all columnvalues

[Anonymous]

Hi!

I need a measure that shows all rows of a column as a text string, disregarding any filters that the user has applied.

I have tried ALL(table[column]) and a bunch of other DAX-epressions, but I get an errror that says that a " A table of multiple values was supplied where a single value was expected"

What should I do?

Regards

Niklas

[v-chuncz-msft]

@Anonymous ,

Make sure you use it in the first argument of CONCATENATEX.

[judspud]

Hi @Anonymous 

You can use the concatenatex function within a measure.

Measure = CONCATENATEX('Table', 'Expression', Delimiter)

Please mark this as the solution if it provides what you need 🙂

Thanks,

George

[Anonymous]

Thanks!

Turns out that when using direct query, it is not possible to use the ALL-function. That means I have to scrap this effort all together. So I could not test our solution. Perhaps somone else can confirm yor solution works.