Including a DAX Measure in a text field

DAX DAX Calculations
2

@llchoong,

Here’s one way to do this using nested CONCATENATE functions (since you can only concatenate two text strings at a time):

Example Label = 

VAR FirstString =
CONCATENATE(
    "This measure is the concatenation of text plus the value of another measure, ",
    [Count Closed Claims]
)

RETURN
CONCATENATE(
    FirstString, ", with more text."
)

image
image1003×484 133 KB

Interestingly, when I put this example together I found there was more formatting flexibility in using a table visual that card visual in which to drop the measure for display.

I hope this is helpful. Full solution file attached.

1 Like