How can I wrap measures in text?

[ERing]

I have two measures (count, % of total count) and want to be able to display the measures in a single card so that the card displays something like " 5,000 (75%)". 

Is this possible?

[v-binbinyu-msft · Accepted solution]

Hi @ERing ,

Please try to create a measure with below dax formula:

Combined Measure = FORMAT([Count], "#,0") & " (" & FORMAT([% of Total Count], "0%") & ")"

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx]

pls try this

final = [measure1]&" ("& [measure2]&" )"

[ERing]

 @Ahmedx  This is very close, however my first measure is missing the "," for thousands and the second measure is displaying as a decimal when I would prefer it to display as a %.

Current result  = "5000 (.25000000000000)

Desired result = "5,000 (25%)"

[Ahmedx]

final =
"""&[measure1]&" ("&FORMAT([measure2],"0%;-0%;0%")&" )""

[ERing]

@Ahmedx I'm getting an error with this suggestion, but we are one step closer.

This is what I have now.
final = [measure1]& " ("&FORMAT([measure2],"0%;-0%;0%")&")"

This is returning 5000 (25%) . All I need now is to format the first measure with a comma seperator.