Forum Discussion

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
6 years ago
Solved

Combine two measure in same column

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...
Need Help
  • az38's avatar
    az38
    6 years ago

    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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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