Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Concatenate Text to a Measure

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.
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

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

5 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • bhanu_gautam's avatar
        bhanu_gautam
        Icon for Super User rankSuper User
        2 years ago

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