Text added to measure error

[ArchStanton]

Hi,

I have the following measure that almost works but I'm seeing 12 decimal places in the result.

Avg Case Length =
CALCULATE (
    AVERAGEX ( 'Cases', 'Cases'[Case Length (Validation Date)] ),
    'Cases'[User Team Name] = "ERT"
) & " Days"

Result = 21.225874125874 Days

How can I make this result just 1 decimal place?

Thanks,

[brokencornets · Accepted solution]

Try this?

Avg Case Length =
FORMAT(CALCULATE (
    AVERAGEX ( 'Cases', 'Cases'[Case Length (Validation Date)] ),
    'Cases'[User Team Name] = "ERT"
),"0.0") & " Days"

[ArchStanton]

Thank you!