Division by categories

[Anonymous]

Hello guys, I would like to do the following division: 

Avg Call length equal to ("Engage Time" plus "Wrap Time") divide "Accepted"

Yet my calculated result seems wrong as the table below

[amitchandak]

@Anonymous , Something like this should work

divide( [Engage Time] + [Wrap Time], [Accepted])

or
divide( table[Engage Time] + table[Wrap Time], table[Accepted])

[Anonymous]

Thanks for your quick reply. 

I tired it before, yet still, fail to show the correct answer:(

[harshnathani]

Hi @Anonymous ,

DIVIDE (
    CALCULATE (
        SUMX (
           'Agent Reort 09',
            'Agent Reort 09'[Engage Time] + 'Agent Reort 09'[Wrap Time]
        )
    ),
    'Agent Reort 09'[Accepted]
)

Pl do let me know if this works.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[Anonymous]

@harshnathani 

It doesn't come up with correct answer as well:(

[amitchandak]

@Anonymous ,Can you share sample data and sample output. Mark me @

[Anonymous]

@amitchandak 

Sample Data:

Agent Name	Queue	Accepted	Engage Time	Wrap Time
a	UNKNOWN	1	985	0
a	VQ_Supervisor_Hotline	1	66	10
a	UNKNOWN	2	273	5
a	VQ_Supervisor_Hotline	1	22	36
a	UNKNOWN	4	2822	0
a	VQ_ElderlyAndDisable	1	42	13
a	VQ_Supervisor_Hotline	1	14	6
a	UNKNOWN	8	8427	0
a	UNKNOWN	10	2599	196
a	UNKNOWN	8	5823	0
a	UNKNOWN	6	2323	8
a	VQ_Supervisor_Hotline	1	78	88
a	UNKNOWN	8	5178	958
a	VQ_ElderlyAndDisable	3	523	65
a	VQ_Supervisor_Hotline	1	148	13
a	UNKNOWN	5	3061	143
a	UNKNOWN	6	1876	0
a	VQ_Supervisor_Hotline	1	12	5
a	UNKNOWN	8	3105	1
a	VQ_ElderlyAndDisable	1	283	426
a	VQ_Lang_English	1	338	75
a	UNKNOWN	6	2147	8
a	VQ_Supervisor_Hotline	1	141	378
a	UNKNOWN	4	3602	147
a	VQ_ElderlyAndDisable	1	330	82
a	UNKNOWN	1	1243	0
a	UNKNOWN	7	2130	143
a	UNKNOWN	1	981	0
a	VQ_Supervisor_Hotline	1	345	438
a	UNKNOWN	5	3224	428
a	VQ_Lang_English	1	556	274
a	UNKNOWN	2	541	0
a	UNKNOWN	3	1148	0
a	UNKNOWN	2	1098	16
a	VQ_Supervisor_Hotline	1	15	4
a	UNKNOWN	6	1951	15

Sample Output 

Agent	Queue	Total Accepted	Total Engage	Total Wrap	Avg Call Length
a	UNKNOWN	103	54537	2068	549.5631
a	VQ_Supervisor_Hotline	9	841	978	202.1111

[harshnathani · Accepted solution]

@Anonymous ,

Call Length = DIVIDE([Total Engage Time] + [Total Wrap Time] , SUM(Table9[Accepted]))

Total Engage Time = SUM(Table9[Engage Time])

Total Wrap Time = SUM(Table9[Wrap Time])

Regards,

HN

[Anonymous]

@harshnathani 

Thanks for your advice. I did so following your instructions yet I found a wired thing that makes an inaccurate result.

The data in the data field following your advice:

The data in the report view and the number was much larger than the data in data view: 

[harshnathani]

@Anonymous ,

You are creating Calculated Column,

You should be creating Measures and not Calculated Columns.

Regards,

Harsh Nathani

[Anonymous]

@harshnathani 

Oh it works!! thanks for pointing out my mistakes. 

I hope you won't mind to answer me the following silly questions. I wonder what's the difference between Measure and Column, they are quite similar to me as both of them are working with Dax for calculation  

[harshnathani]

 Hi @Anonymous ,

The difference is the context of evaluation.

A measure is evaluated in the context of the cell evaluated in a report or in a DAX query, whereas a calculated column is computed at the row level within the table

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!