Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi,
You could try using the solution provided here
Measure = CONCATENATEX ( VALUES ( Table2[Name] ), Table2[Name], ", " )
Hi,
You could try using the solution provided here
Measure = CONCATENATEX ( VALUES ( Table2[Name] ), Table2[Name], ", " )
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |