Forum Discussion
Solved
Expression Error
Hello, How do I fix this error? Thank you!
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.
Hi again,
It works:
But when I click "Overdue" and "Coming Due" is there a way for it to say 0%?
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.
This is exactly what I need! Thank you!!