summarized values with , seperator in dax

[Anonymous]

Dear all,

I have a table:

Product	Location
A	1
A	2
A	3
B	1
B	3
C	4
D	1
D	2
D	3
D	4

And i would like to create a table ( in a visual) like this:

Product	Location combined
A	1,2,3
B	1,3
C	4
D	1,2,3,4

is this possible in DAX?

so to my understanding it can either be a measure or calc column.

best

[Gordonlilj · Accepted solution]

Hi,

You could try using the solution provided here

Measure = CONCATENATEX ( VALUES ( Table2[Name] ), Table2[Name], ", " )

[Anonymous]

Hi @Gordonlilj 

I used your formula and in my table it gives me the requested result. however if i add a total bar in my table it will give all the values concatenated. is this solvable in a way, that if you have the total bar, it wil give you a "*" saying that it is too many values or something.

[Gordonlilj]

One way you could try is to use the solution provided in this post

So something like this perhaps

if(HASONEVALUE('Table'[Product]),[Measure],"*")

Or you could try and hide the total for just the measure by changing the font and background colors. This can be done under field formatting and just apply it to total.