Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    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!

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

     

    I filtered out Coming Due in the pie chart visual

     

    Oooh, two mistakes for the price of one 🙂  .

     

    A pie chart ONLY makes sense if you DON'T filter out vital parts. By definition it will ALWAYS need to show 100%.

     

    Use a different visual.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    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!