Divide 2 Measures with 2 Different Slicers (Filtering)

[Anonymous]

This post has now been deleted.

[Jihwan_Kim]

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 )

https://www.dropbox.com/s/dhjdl1t3ljwprys/Mehal1996.pbix?dl=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]

This post has now been deleted.

[Jihwan_Kim]

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?

[Anonymous]

This post has now been deleted.

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture whether it is what you are looking for.

The link to pbix file is down below, and the measure is written in the file.

https://www.dropbox.com/s/dhjdl1t3ljwprys/Mehal1996.pbix?dl=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]

This post has now been deleted.

[Jihwan_Kim]

Hi, @Anonymous 

I think I misunderstood the meaning of overall value.

In my calculation, the definition of overall value was, 

(0+100% + 67% +0%) / 4

But, you want to show the overall like,    assigned account(5) /  total account (6) = 5/6 = 83.33%, am I correct?

I have changed the measure, and please check the link below.

https://www.dropbox.com/s/dhjdl1t3ljwprys/Mehal1996.pbix?dl=0 

And your second question is, in my opinion, doable.

If you can provide it with some sample data, I can try to look into it to come up with more accurate measure.

Thank you very much.

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.