Count of Records upon slicing the data divided by Total Record counts

[vidyasagar159]

Hi,

I am a new bee. I have a small requirement. I want find the Active percentage of Employees of each manager. From the below sample data.

Lets say, From the slicer if I select a Manager called Brayn then I want to know the active percentage of his employees. Some one please help me with the expression.

Manager	Employee	Status
Brayn	Riki	Acctive
Brayn	John	Passive
Brayn	Jessi	Active
Chris	Stuart	Active
Chris	Robin	Passive
Chris	sam	Passive
Chris	peter	Passive

[vidyasagar159]

I guess, I found the solution.  For the Manager "Brayn"

Step1: Active Employees Measure =   COUNTROWS(FILTER(Master,Master[Employee]="Active"))

Result = 2

Step2: Total Employee Measure = COUNTA(Master[Employee])

Result = 3 

Step3:  Active Employees Measure /  Total Employee Measure (2/3) = 66%

There  might be a simple method. But  this  solved my  issue as of  now

Thanks,

-Vidya

[Phil_Seamark · Accepted solution]

HI @vidyasagar159

Please add the following two calculated measures

Total Active Employees per Manager = 
    CALCULATE(
        COUNTROWS('Table1'),
        FILTER(
            ALL('Table1'),
            [Manager] = MAX('Table1'[Manager]) && 
            [Status] = "Active"
            )
           )

Total Employees per Manager = 
    CALCULATE(
        COUNTROWS('Table1'),
        FILTER(
            ALL('Table1'),
            [Manager] = MAX('Table1'[Manager])
            )
           )

finally

Ratio = DIVIDE([Total Active Employees per Manager],[Total Employees per Manager],0)

[vidyasagar159]

Hi @Phil_Seamark,

Mine is only working in Cards. when I am applying the same inside a table total count is filtering out and i am always getting 100%. But your code is perfectly working in a table. 

I really appreciate your help. 

Thanks,

-Vidya

[vidyasagar159]

Hi,

Thanks for looking into this issue. So is there any difference between our logic? 

Thanks,

-Vidya