how to recall values from a column with a measure or calculated column

[Anonymous]

Hi, I want to create a measure or calculated column (I don't know what is needed between these two) that displays me all the values of a given column in a table or other chart. How can I write this function?
I have created this measure
sales = selectcolumns(ART, ART[vend]) but if I try to put this measure in the table, no value is displayed.

How can I fix this?
thanks!

This is because I imported the tables with direct query, but I want to divide certain columns and measures into categories. And the 'only way to do that, is to create calculated measures or columns and put them in folders/categories.

[Anonymous · Accepted solution]

Hi @Anonymous ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Chage the measure like this

Measure = SELECTCOLUMNS('Table',"Part",SELECTEDVALUE('Table'[Part]))

Final output

You can refer to this document

SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[AngeloParana]

You cannot store a multiple values in a single cell. The way to do it is do a ConcatenateX function