Avg invoice amount by s/m

[BORUCH]

hi all

i have the below power piviot table (data model)

cust #	saleaman	inv#	item #	qty	price	amount
a1	jack	1	11	2	12.00	24.00
a1	jack	1	12	3	10.00	30.00
b1	john	2	11	1	12.00	12.00
b1	john	2	12	3	5.00	15.00
b1	john	2	13	5	6.00	30.00

<tbody>
</tbody>

i would like to get a measure that would give me average invoice amount

what it would have to do is total up the amount column for each invoice and then give me an average of that total

how can i accomplish that? any help is appreciated

thanks

 

[BORUCH]

Any updates?

 

[akice]

if you have a table/matrix with Cust # and Inv# on rows, just a measure: AVERAGE ( Table[amount] ) should do it.

If not, how do you want results to look?