u/Effective-You1036

I didn't intend to :-D

Yesterday, on Tues, I had lunch w some colleagues. As always, I had set my timer to 55 minutes (my eating windows for 2MAD).

reached home, thought I'd take a nap before dinner. But apparently, I was so tired that I didn't wake up for dinner.. glanced a couple of times to check what tie it was, and fell asleep again.

Woke up this morning (Wed). Then I said to myself, push it until lunchtime, and you'll have passed the 24-hrs!

I feel great:-)

However, the morning was brutal.. I dont know how some of you manage 24 hrs every few days

I have this table with District Nums and County Names.
How do I write a DAX column that will partition by DistrictID, and the new column will contain concatenated County Names belonging to that district.
For ex, Row 1 will have BARTOW, CATOOSA, CHATTOO, CHEROKEE, etc (Dont ask me why; its user requirement!)

I have tried this: It gives only current county name. What am I missing?

Column 4 = 
VAR CurrentDistrict = 'luCounty'[luCountyDistrictNum]
RETURN
CALCULATE(
    CONCATENATEX(
        VALUES('luCounty'[luCountyName]), 
        'luCounty'[luCountyName], 
        ", "
    )


,    'luCounty'[luCountyDistrictNum] = CurrentDistrict
)

DistrictID	CountyID	CountyName	New Column
80	8	BARTOW	BARTOW, CATOOSA, CHATTOOGA, CHEROKEE, QUITMAN
80	9	CATOOSA	BARTOW, CATOOSA, CHATTOOGA, CHEROKEE, QUITMAN
80	10	CHATTOOGA	BARTOW, CATOOSA, CHATTOOGA, CHEROKEE, QUITMAN
80	11	CHEROKEE	BARTOW, CATOOSA, CHATTOOGA, CHEROKEE, QUITMAN
80	12	QUITMAN	BARTOW, CATOOSA, CHATTOOGA, CHEROKEE, QUITMAN
90	13	RANDOLPH	RANDOLPH, SEMINOLE
90	14	SEMINOLE	RANDOLPH, SEMINOLE
101	15	WHITE	WHITE, UNION, TOWNS
101	16	UNION	WHITE, UNION, TOWNS
101	17	TOWNS	WHITE, UNION, TOWNS