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

 

Almost there. The invoice count is not a measure. It is created by using the count distinct feature  of invoice numbers that relate to the customer in column 1. So  right now getting $0 in that column.

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

Hi sbmeder,

 

Have you tried the formula provided by MalS above? It should work in your scenario. If you still have any question, feel free to ask.:smileyhappy:

 

Regards

  • sbmeder's avatar
    sbmeder
    Helper I
    9 years ago

    Unfortunately, I have not had a chance.  I have finally gotten my owner's attention with this product and what it can do for the Company. What is the best way to find consultants to help structure reports so we can slice and dice the data.  My main issue is dealing with the date functionality. I am not a programmer, and I know BI will do what I want it to do, but I have no idea how to write DAX.  looking at customer sales, last month vs this month. Last year vs This year. Same thing with Product lines and Geographic data. 

     

    Any help would be appreciated. 

     

    Regards,

     

    Scott

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

    Hi sbmeder,

     

    That's all right! We have a lot DAX experts in the forum. If you have any issue with DAX, just create a new thread, and post your table structures with some sample data and your expected result. I'm sure you will get the issue resolved.:smileywink:

     

    Regards