Expression Error

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.