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

     

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

sbmeder's avatar
sbmeder
Helper I
9 years ago

Not a programmer so maybe syntax wrong. This is what I got from the formula.