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

     

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

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

  • 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

     

  • 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

  • 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