Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago
Solved

Text added to measure error

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,

Need Help
Show and Tell
  • brokencornets's avatar
    brokencornets
    3 years ago

    Try this?

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

2 Replies

  • brokencornets's avatar
    brokencornets
    Icon for Helper IV rankHelper IV
    3 years ago

    Try this?

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