Creating a measure to select all values of a column

[rkumar]

Hi All,

We have a requirement where we need to have the distinct values of a column in a measure , Can that be done in dax query  or some other way.

[Stachu]

you can use CONCATENATEX in DAX

Measure = CONCATENATEX(DISTINCT('Table'[Column]),'Table'[Column],",") 

[rkumar]

We just need distinct values of one column in measure, but measure dosent accepts column without any aggregate function or expression.
Thats the block.

[Stachu]

CONCATENATEX is aggregating the values from the column into string - have you tried the code I've sent?

[rkumar]

Yes, i tried.  But due to some reason in september update of PowerBI i am not able to see CONCATENATEX function while creating a measure . Tried same with earlier version of power BI and its working there.

While creating measure not able to see CONCATENATEX function.

Thank You

[v-chuncz-msft]

@rkumar,

Make sure it is a measure, not calculated column.

[Stachu]

from what I see in your screenshot tha Data View is missing as well, so maybe there is something wrong with your instalation - I use the latest version of PowerBI and CONCATENATEX is there

for the View issue you can try going pressing Home>Edit Queries
https://community.powerbi.com/t5/Desktop/No-Data-View-Option/td-p/18003

it solved the issue for some, maybe it will fix it for you as well

[rkumar]

Is dataview availabkle in direct query mode.