@lbendlin , here is more details.
I have 4 tables: Agents Name, AGENTS_15MINS_VIEW, Dates, and Time. AGENTS_15MINS_VIEW table contain information related to call handled by agents in 15 mins intervals. The table has information like how many calls handled in 15 mins interval, date, and agent name (i.e. who handled call). AGENTS_15MINS_VIEW is fact table which has many to one relationships with other dimensions tables (i.e. Agent Name, dates, and time). I have drop down list which contains the name of agents that comes from Agent Name table. I created two measures. One measure should calculate the average call handled by selected agent per hour and second measure should calculate the average call handled by all agents per hour. Measures are defined as follow:
Avg contact handled by selected agent per hour =
Averagex(
SUMMARIZE(ADDCOLUMNS(AGENTS_15MIN_VIEW, "Hour",HOUR(AGENTS_15MIN_VIEW[Time]), "Week",WEEKNUM(AGENTS_15MIN_VIEW[Start Date])), [Hour], [Week], "Calls attended", SUM(AGENTS_15MIN_VIEW[Contacts handled incoming]) ),
[Calls attended] )
Avg contact handled by all agents per hours =
AVERAGEX(
SUMMARIZE(
AGENTS_15MIN_VIEW,
'Dates'[Week Number], 'Time'[Hour Number],
"Avg", CALCULATE( DIVIDE(SUM(AGENTS_15MIN_VIEW[Contacts handled incoming]),DISTINCTCOUNT(AGENTS_15MIN_VIEW[Agent Name])))
),
[Avg]
)
The second measure shows average call handled by all agents per hour until we select specific agent name from agent drop down list. As soon as we select agent name from drop down list, it shows the same calculation as the first measure shows i.e. average call handled by selected agent. I want second measure to show the average call handled by all agents per hour irrespective of agent name selection from the drop down list. Could you please help me in fixing the issue?
