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