sbmederHelper I9 years agoSolvedAverage 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...Show MoreVvelarde to sbmeder9 years agosbmeder You can use the same Dax Formula like a measure instead of a calculated Column
Vvelarde to sbmeder9 years agosbmeder You can use the same Dax Formula like a measure instead of a calculated Column
Vvelarde to sbmeder9 years agosbmeder You can use the same Dax Formula like a measure instead of a calculated Column
MalSResolver III9 years agoAhh - ok. Maybe try: Average Invoice Value = DIVIDE ( SUM( 'Table Name'[Sum of Price]), DISTINCTCOUNT('Table Name'[Sales Invoice Number] ))
sbmederHelper I to MalS9 years agoMal, 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.
Related contentFinding Average Unit Price Across InvoicesValues not averaging correctly based on dateAverage and Moving AveragePDF InvoiceAverage value based on multiply samples per second, Average by minute
