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 shows average invoice value per customer. 

 

Regards,

 

Scott

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

     

18 Replies

  • mattbrice's avatar
    mattbrice
    Solution Sage
    9 years ago

    Can you just divide the gross sales value measure by the number of invoice measure you already have?

    • sbmeder's avatar
      sbmeder
      Helper I
      9 years ago

      Matt,

      Dont think so. Using the BI functions to key off customer name, aggregate invoice value into total value, then using the count distinct function to determine qty of invoices. So I have all the pieces of the puzzle, but not familiar enough with the BI product. I dont think I can add a calcuation at the report level?

       

       

       

       

       


      Scott

      • mattbrice's avatar
        mattbrice
        Solution Sage
        9 years ago

        "I dont think I can add a calcuation at the report level?"

         

        I don't understand what you are saying here.  You only want at a grand total line? How are the other two columns calculated?  As measures or calculated columns?