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

Data is from a direct query.  What is the best way to get you what information you need.

 

Regards,

 

Scott

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

Hi sbmeder,

 

Is it possible for you to create a new sample pbix file to import the table from your data source, then share it with us?:smileyhappy:

 

Regards

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    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

    I have the provided sample data.  I select customer number, then data field " Sum of Price" bad name for a data field and let BI summarize the values for all transactions for each customer number.  Then I select Invoice number and ask for distinct count to get the number of invoices. Hope this helps explain the situation. 

     

    https://ebsbi.sharefile.com/d-sae5c5584a564dc8b

     

    Regards,

     

    Scott