Help with measure, average number of calls done by agent per day

[DrTorrontegi]

Hi all,

I'm looking to undestand what is the average number of calls done by agent per day, i could calculate the average number of calls per agent AVERAGEX(values(TableCalls[idAgent]);COUNTROWS(TableCalls)) buy i don't know how to add the Day dimmension on the Measure.

I hope anyone will help.

Best Regards

David

[dax]

Hi @DrTorrontegi , 

You could refer to @az38 's suggestions, If this don't work, please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DrTorrontegi]

Hi,

I have changed a bit the measure, i'm looking for a Deviation Chart like the attached but i don't know how to make this, any idea?

Regards

[dax · Accepted solution]

Hi @DrTorrontegi , 

You could try to use hierarchy to achieve this goal, or you could summarize table , then create measure to achieve this goal. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DrTorrontegi]

Thanks!

This an amazing solution!

I'm going to test it!

Table 2 = SUMMARIZE(T1;T1[idEquipo];T1[psudonimo]; "count p"; COUNT(T1[psudonimo]);"count rows"; CALCULATE(COUNT(T1[psudonimo]); ALLEXCEPT(T1;T1[idEquipo])); "count dist"; CALCULATE(DISTINCTCOUNT(T1[psudonimo]); ALLEXCEPT(T1;T1[idEquipo])))

[az38]

Hi @DrTorrontegi 

try smth like

=CALCULATE(COUNTROWS(TableCalls); ALLEXCEPT(TableCalls; TableCalls[idAgent]; TableCalls[Date].[Date]) )