Forum Discussion

Mat87's avatar
Mat87
Frequent Visitor
9 years ago
Solved

Getting a simple average (measure)

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. 

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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])
				)

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    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's avatar
      Mat87
      Frequent Visitor
      9 years ago

      Yeah that worked great. 

       

      Thanks, Phil.