Add text string to value

[Lauraeire_81]

Hi

I am looking to add a text value to a Calculate value. 

CALCULATE(DISTINCTCOUNT('Report Results'[Critical areas])

I would like to add a text strings at both ends like this;

"The total is" & CALCULATE(DISTINCTCOUNT('Report Results'[Critical areas])&"critical areas".

Thanks for your help.

Regards,

Laura

[bhanu_gautam · Accepted solution]

@Lauraeire_81 To achieve this in DAX, you can use the & operator to concatenate text strings with your calculated value

"The total is " & CALCULATE(DISTINCTCOUNT('Report Results'[Critical areas])) & " critical areas"

[johnt75 · Accepted solution]

Another option is use a dynamic format string. The advantage of this approach is that the measure still returns a numeric value, which means you can use it in chart visualisations and also use it in other measures, e.g. to calculate averages.

To use a dynamic format string, choose Dynamic from the Format dropdown and use a DAX formula like

"The total is " & FORMAT(SELECTEDMEASURE(), "#,0") & " critical areas."

[rohit1991]

Hi @Lauraeire_81

To append a text string to a numeric value (like adding the label "critical error" to a number), you can use the & operator in DAX to concatenate text and numbers.

However, since you're working with a numeric measure, you'll first need to convert that number to text using FORMAT().

"The total is " & FORMAT([Report Result], "0.0") & " - critical error"

This will return something like: "The total is 98.5-critical error"

If you're using this in a card visual or tooltip, this should display correctly. Just make sure your measure is of type text, especially if you’re mixing strings and numbers.

[bhanu_gautam · Accepted solution]

@Lauraeire_81 To achieve this in DAX, you can use the & operator to concatenate text strings with your calculated value

"The total is " & CALCULATE(DISTINCTCOUNT('Report Results'[Critical areas])) & " critical areas"