Expression Error

[racheljeska]

Hello,

How do I fix this error? Thank you!

[Anonymous]

Hi,

Thanks for the solution @Anonymous  provided, and i want to offer some more information for user to refer to.

hello @racheljeska , based on the picture you have offered, your completedEval/allEval return a number type, but the "-" is text type,so it will cause the error, you need to change the if situation to the following.

IF (
    NOT ( ISFILTERED ( 'All Incident Evaluation -OSHA'[Status] ) ),
    completedEVAL / allEVAL
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[racheljeska]

Hi Yolo Zhu, 

The expression went through, but it is not displaying the same percent as in the pie graph: 

[Anonymous]

Hi @racheljeska 

Based on your description, please consider to change the calculated column to measure.

Measure =
VAR completedval =
    CALCULATE (
        COUNT ( table[status] ),
        ALLSELECTED ( table ),
        tale[status] = "Completed"
    )
VAR alleval =
    CALCULATE ( COUNT ( table[status] ), ALLSELECTED ( table ) )
RETURN
    completedval / alleval

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[racheljeska]

Hi again, 

It works: 

But when I click "Overdue" and "Coming Due" is there a way for it to say 0%?

[Anonymous · Accepted solution]

Hi @racheljeska 

You can try the following

MEASURE =
VAR completedval =
    CALCULATE (
        COUNT ( table[status] ),
        ALLSELECTED ( table ),
        tale[status] = "Completed"
    )
VAR alleval =
    CALCULATE ( COUNT ( table[status] ), ALLSELECTED ( table ) )
RETURN
    IF ( ISFILTERED ( table[status] ), 0, completedval / alleval )

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[racheljeska]

This is exactly what I need! Thank you!!

[Anonymous]

I thought variables could only be used in a measure, not a calculated column.

--Nate