Filter contains multiple name values select name to update all visuals

Hi dd999 ,

try below:

Total_Count_staff1 =
var selected_agent=SELECTEDVALUE(AgentTimelineAnalyticsRaw[Agent Name])
RETURN
CALCULATE(
COUNTROWS(AgentTimelineAnalyticsRaw),
REMOVEFILTERS(AgentTimelineAnalyticsRaw),
AgentTimelineAnalyticsRaw[Agent Name] = selected_agent
)

Average Call Length_MCM_staff1 =
var selected_agent=SELECTEDVALUE(AgentTimelineAnalyticsRaw[Agent Name])
RETURN
CALCULATE(
AVERAGE('AgentTimelineAnalyticsRaw'[Call Duration Minutes_Clean]),
REMOVEFILTERS('AgentTimelineAnalyticsRaw'),
'AgentTimelineAnalyticsRaw'[Agent Name_combine] = selected_agent
)

Pleas egive kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

Hi dd999 ,

you just need to remove second section from your measures and just select in the slicer. these are your updated measures...

Total_Count =
CALCULATE(
COUNTROWS(AgentTimelineAnalyticsRaw))

Average Call Length_MCM =
CALCULATE(
AVERAGE('AgentTimelineAnalyticsRaw'[Call Duration Minutes_Clean]))

If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution ✔️ to help the other members find it more quickly.