Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Concatnate a Measure and Column

Hi,  I have a requirement to show the title of a multi row card (highligthed in the snip) as combination of a Text, column and a Measure.  I am able to get the values correctly for each individual ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous have you tried CONCATENATE function. 

     

    Measure = CONCATENATE(MAX(PageAttempts[Column]),CONCATENATE(": ",CONCATENATE([TotalSuccess],CONCATENATE("/",[Total]))))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Thank You Vimal for helping out here. 

However the measure work perfectly in table but when it is added to a Multi Row Card visual, it does not group based on "Steps" column rather it just gives the total.

 
Measure = CONCATENATE(MAX(PageAttempts[Step+Stepname]),CONCATENATE(": ",CONCATENATE([TotalSuccess],CONCATENATE("/",[#Total]))))

card marked in red use the new Measure

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous something like this?