Average # Returns Per Customer Per Employee

[jb00976]

I am very new to PowerBI so this may be a simple questions but, I don't know how to do it yet!

If I had a list of employees and their customer return rate like this:

Employee	Customer	# Return
Joe	ABC Co.	3
Sam	DEF Co.	3
Joe	GHI Co.	0
Sam	JKL Co.	1
Joe	MNO Co.	1
Sam	PQR Co.	0
Joe	STU Co.	0

I am looking to be able to to show on a chart the employees average # of returns per customer (i.e. for Joe it would be 4 total returns divide 3 total customers which equals 1.3 returns per customer on average) how would I get a field to be able to show that in a chart.

Thank you in advance for any help.

 

[macfuller]

Try something along the lines of

Returns per Customer :=
VAR customer_returns =
    SUM ( MyTable['# Return'] )
VAR customer_count =
    DISTINCTCOUNT ( MyTable[Customer] )
VAR avg_returns_per_customer =
    DIVIDE ( customer_returns, customer_count )
RETURN
    avg_returns_per_customer

This is pretty simple, and you see the measure doesn't mention employees, so it assumes you would be listing the employees in rows of the pivot table to get their values, then you could create a pivot chart showing employees along the x-axis and their returns on the y-axis. You would need to make sure you set filters or slicers for any other conditions you wanted (e.g. date ranges etc.)

I remember being a newcomer to Power Pivot. Write the measures as broadly as possible and let the pivot tables do the work.