Combine two measure in same column

[Mous007]

hi all,

I have two measures working perfectly but i was asked if i could combine both in the same column.

my two measures output is the following :

Variation of users vsLM	% Variation of active users vsLM
-1	-9%
-10	-67%
-9	-43%
-1	-50%
-4	-57%
-2	-67%
10	0%
-8	-32%

i want the output to be in a column in the following format: e.g. (-1) \ (-9%)

i tried a couple of alternative with concatenate but with no results and i was thinking mazbe i should switch to calculated columns to make it easier?. 

i would really appreciate if anybody can help me up or set me in the right way ?

Thanks in advance.

[az38 · Accepted solution]

Hi @Mous007 

use CONCATENATE() function like

Measure = 
var Measure1 = CALCULATE(SUM(Table[Value1]))
var Measure2 = CALCULATE(SUM(Table[Value2])) 
RETURN
CONCATENATE(Measure1, CONCATENATE(" / ", Measure2))

but data format will depend on your measures

[Mous007]

Thanks a lot @az38 , it is working perfectly,

As you said the only issue is with the formatting but i am playing around with the format function to solve it.

Many thanks again