Forum Discussion
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.
Hi Yolo Zhu,
The expression went through, but it is not displaying the same percent as in the pie graph:
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.
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!!