Forum Discussion

sbmeder's avatar
sbmeder
Helper I
9 years ago
Solved

Average Invoice Value

Have a table that displays customer name, customers gross sale values for a filtered time period and the number of invoices relating to those sales. Want to add another column in the report that show...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    sbmeder

     

    You can use the same Dax Formula like a measure instead of a calculated Column

     

sbmeder's avatar
sbmeder
Helper I
9 years ago

 

Matt,

On the report I want to add a column to the right that has the average invoice value for each customer. So as an example complete pool and spa part supply would have the value of 134.80 divided by the 3 invoices that created that gross  Revenue. In an excel summary I would just add that column to the sheet.  I would think you could add a column in the visualization table where that value could be calculated.

 

 

MalS's avatar
MalS
Resolver III
9 years ago

I think that mattbrice was suggesting that you add a new measure to do the calculation, then add that measure to the table. 

 

For example:

1. Click Modeling > New Measure

2. Type the formula, e.g:

          Average Invoice Value = DIVIDE ( [Sum of Price], [Count of Sales Invoice Number] )

3. Add that measure to the Values of your table