Getting a simple average (measure)

[Mat87]

So I have a table that basically looks like this:

I want to create a measure that give me average sales per transaction.  Thing when I create a column dividing sales by transactions it give me average sales per employee but but the values for other categories (department, city etc) are wrong, even when I choose the summaraize by avaerage option in the pivot table. 

[Phil_Seamark · Accepted solution]

Hi @Mat87

Have you tried creating it as a calcuated measure rather than as a calcuated column?

How does this look?

Measure = DIVIDE(
				SUM(Table1[Total Sales]) , 
				SUM(Table1[Total Transactions])
				)

[Mat87]

Yeah that worked great. 

Thanks, Phil.