% population meeting target

[vivran22]

Hello folks,

I have a scenario where I need help.

Objective is to calulate % population meeting the target, by:

• Supervisor
• Month

I have two data tables: AHT Performance & Target

The formula would be simple: (Count of agents meeting target/ Total agents in the team or month)

I am enclosing the sample pbix file for your reference. % population meeting target.pbix

Any help/guidance will be highly appreciated.

Thanks,

Vivek

[vivran22]

@Ashish_Mathur 

Can you please help me with this?

Thanks,

Vivek

[Ashish_Mathur]

Hi,

I cannot visualise your expected result.  Explain the business question and show the result clearly in a Table format with an explanation of how you arrived at the expected result.

[vivran22]

@Ashish_Mathur 

Hello,

Thank you for your response.

Below are two sample tables for the expected results:

Hope this explains the requirement.

Thanks,

Vivek

[vivran22 · Accepted solution]

Figured out the solution:

Measure 1:

Population Count = COUNTROWS(dtTable)

Measure 2:

Meeting AHT Target = 
CALCULATE (
    [Population Count],
    FILTER ( dtTable, [Avg Handle Time] <= RELATED ( dtTarget[AHT tgt] ) )
)

Measure 3:

% Population Meeting Target = DIVIDE([Meeting AHT Target],[Population Count])

Enclosing the sample pbix file here

Vivek

[Ashish_Mathur]

Hi,

How did you compute the figures of 41, 38 45 etc.  Please be descriptive/clear.

[v-eachen-msft]

Hi @vivran22 ,

You could move the target to the main table with USERELATIONSHIP() function like the following DAX:

Talk tgt =
CALCULATE (
    SELECTEDVALUE ( dtTarget[Talk tgt] ),
    USERELATIONSHIP ( dtTarget[Product], dtTable[Product] )
)

 Then you could use COUNTROWS() to get values.