Need help listing string items in a column in a table

[Anonymous]

Hello everybody,

I'm a DAX and BI newbie, so please forgive me if this is this is a "duh" moment.

In learning DAX, I created a Matrix table that lists "Yearly Income" ranges on rows and then I created a DISTINCTCOUNT measure that lists how many "Occupations" from my dim table (5 occupations total) are represented in each salary range.

Over on the left are the five occupation options available.

I was challenging myself to create a new measure that would, in a column, basically concatenate once each occupation represented in my distinct count of occupation column. So, for example, in my $160,000 salary bracket that has 2 occupations represented, if those two occupations were "Management" and "Professional", in the next column I wanted "Management, Professional" to appear.

Everything I tried would return every occupation per customer, leading to thousands of occupations strung one after another.

Other stuff I tried just broke the table and couldn't be displayed, or created other odd things.

I tried various combinations of CONCATINATE, CONCATINATEX and DISTINCTCOUNT, but with no luck.

Is this something do-able?

Thanks everybody. The forums have become a great tool for me.

[GilbertQ · Accepted solution]

Hi @Anonymous

Try this following measure below, which should give you the desired result

Occupations Represented = CONTATENATEX(VALUES('Tablename'[Occupation]),
    'TableName'[Occupation],",")

[Anonymous]

Awesome! That did it. Thanks a ton guavaq. I'm in awe of your DAX mastery! 🙂

[GilbertQ]

Happy to help out @Anonymous

And we all hard to start at some point, I have no doubt you will gain knowlege the more you work with DAX.