Forum Discussion

7 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    Please correct me if I wrongly understood your question.

    If the below picture is what you are looking for, please try the below measure.

    I also attached the link of sample pbix file down below.

     

     

    Manager involve ratio =
    VAR employeeinvolvecount =
    COUNTROWS ( 'Table' )
    VAR managerinvolvedcount =
    CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
    'Table',
    'Table'[Account Aligned Manager]
    = SELECTEDVALUE ( 'Table'[Manager of Employee] )
    )
    )
    RETURN
    COALESCE ( DIVIDE ( managerinvolvedcount, employeeinvolvecount ), 0 )
     
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This post has now been deleted.

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        5 years ago

        Hi, Anonymous 

        Thank you for your reply.

        So sorry to say that now I am confused. In the last picture, John's ratio is 75%?

        Then how about James? Is James's ratio 100% 

        Or, in AccountSTID #6, "John" and "No Employee Task" is misplaced?