Combine two measure in same column

Question

hi all,&nbsp;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 :&nbsp;Variation of users vsLM% Variation of active users vsLM-1-9%-10-67%&nbsp;&nbsp;-9-43%-1-50%&nbsp;&nbsp;-4-57%&nbsp;&nbsp;-2-67%&nbsp;&nbsp;100%&nbsp;&nbsp;-8-32%&nbsp;i want the output to be in a column in the following format: e.g. (-1) \ (-9%)&nbsp;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?.&nbsp;&nbsp;i would really appreciate if anybody can help me up or set me in the right way ?&nbsp;Thanks in advance.

az38 · Accepted Answer

Hi&nbsp;Mous007&nbsp;
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

Forum Discussion

Combine two measure in same column

2 Replies

Related content

Combine Column

Combining Column Data

Combine columns into 1

Tables combine

Combine Columns in a Measure

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%