Forum Discussion

racheljeska's avatar
racheljeska
Frequent Visitor
2 years ago
Solved

Expression Error

Hello,   How do I fix this error? Thank you!
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
racheljeska
Frequent Visitor
2 years ago

Hi Yolo Zhu, 

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      racheljeska
      Frequent Visitor
      2 years ago

      Hi again, 

       

      It works: 

       

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.