Forum Discussion
Add text string to value
Hi
I am looking to add a text value to a Calculate value.
CALCULATE(DISTINCTCOUNT('Report Results'[Critical areas])
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"
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."
3 Replies
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"
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.
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."
