Concatenate Values

[Anonymous]

Hi Experts

Is it possible to concatentate three measure to produce the following output...

Measure 1 (measure 2, Measure 3)

11.82 (11.32, 12.45)

so the above is my result in power BI.

[Anonymous · Accepted solution]

@Anonymous , try this DAX measure:

Combined Measure = 
VAR Part1 = [Measure 1]
VAR Part2 = [Measure 2]
VAR Part3 = [Measure 3]
VAR Result = 
	Part1 
	& " ("
	& Part2
	& ", "
	& Part 3
	& ")"
RETURN
Result

[Anonymous]

many thanks Chris....Excellent feedback. Works prefectly.

[Anonymous]

You can concatenate within a concatenate, if that's whatyour asking.

Can you show the data you wan't to get that ouput from?