Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 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 Da...
Need Help
Show and Tell
  • brokencornets's avatar
    brokencornets
    2 years ago

    Try this?

    Avg Case Length =
FORMAT(CALCULATE (
    AVERAGEX ( 'Cases', 'Cases'[Case Length (Validation Date)] ),
    'Cases'[User Team Name] = "ERT"
),"0.0") & " Days"
brokencornets's avatar
brokencornets
Helper IV
2 years ago

Try this?

Avg Case Length =
FORMAT(CALCULATE (
    AVERAGEX ( 'Cases', 'Cases'[Case Length (Validation Date)] ),
    'Cases'[User Team Name] = "ERT"
),"0.0") & " Days"
ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

Thank you!