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.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

     

    --Nate

  • 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.