Forum Discussion
% Completion
- Anonymous2 years ago
Hi racheljeska
Not sure if I understand your requirement correctly. If you want to display the % Completion result in a separate visual like a Card visual, you can create a measure like below, then add it to the Card visual.
% completion = DIVIDE ( CALCULATE ( COUNT ( 'Table'[Employee ID] ), 'Table'[Completion Status] = "Completed" ), CALCULATE ( COUNT ( 'Table'[Employee ID] ), 'Table'[Completion Status] IN { "Completed", "Overdue" } ) )And in the Data pane, select this measure, go to Measure tools ribbon to format it as Percentage.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi racheljeska
Not sure if I understand your requirement correctly. If you want to display the % Completion result in a separate visual like a Card visual, you can create a measure like below, then add it to the Card visual.
% completion =
DIVIDE (
CALCULATE (
COUNT ( 'Table'[Employee ID] ),
'Table'[Completion Status] = "Completed"
),
CALCULATE (
COUNT ( 'Table'[Employee ID] ),
'Table'[Completion Status] IN { "Completed", "Overdue" }
)
)
And in the Data pane, select this measure, go to Measure tools ribbon to format it as Percentage.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!