Forum Discussion

racheljeska's avatar
racheljeska
Frequent Visitor
2 years ago
Solved

% Completion

I filtered out Coming Due in the pie chart visual  I need the equation to do # completed / (Completed + Overdue) x100 = 96.94% The answer should match what is in the pie chart    
  • Anonymous's avatar
    Anonymous
    2 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!