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

Mal,

 

 

Finally had a chance to use your suggestion, still not getting the correct calculation.  For Leslie's the average invoice value should be 22.34. 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi sbmeder,

 

A little weird. The formula seems all right.

 

Could you share a sample pbix file which can reproduce the issue? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

Regards