Concatenate Text to a Measure

[Anonymous]

Hello.

I have this measure that I am currently visualizing inside a card visual.

Average_Time_Response (Days) = CALCULATE(SUM('TABLE'[Time_Response]),'TABLE'[ResponseDate/Time]<>BLANK())

/[# Responded]

So, the card will show, for example, "2"

But I want to add the text "Days" after the card value.

How do I do that? How do I concatenate "Days" so the card value shows "2 Days" and not just "2"?
Thanks.

[bhanu_gautam]

@Anonymous , You can try like this

Average_Time_Response (Days) = VAR AvgResponse = CALCULATE( SUM('TABLE'[Time_Response]), 'TABLE'[ResponseDate/Time] <> BLANK() ) / CALCULATE( COUNTROWS('TABLE'), 'TABLE'[ResponseDate/Time] <> BLANK() ) RETURN CONCATENATE(AvgResponse, " days")

Please accept as solution if it helps

[Anonymous]

Thanks. What happened to the original denominator [# Responded]?

[bhanu_gautam · Accepted solution]

Average_Time_Response (Days) with Text = CALCULATE( SUM('TABLE'[Time_Response]), 'TABLE'[ResponseDate/Time] <> BLANK() ) / [# Responded] & " Days"

[Anonymous]

Works! Thanks!

[bhanu_gautam]

@Anonymous , Welcome