SUMMARIZE (grouping by columns) and summing another

[heathernicole]

Was trying to figure out how to Group By two columns (from two separate (but related) tables). Then finding the sum from another related column in a different table.

Group by Customer, Sales Rep and Sum Invoice totals - Goal: to determine the total amount of invoiced sales for each rep.

Total Dollars = GROUP BY(Sales Rep[Sales Rep Name], SUM(Sales Details[Sales Line Sales Amount]))

I also need to round these final figures up. 

[heathernicole · Accepted solution]

Here's what I did to solve this one. Any ideas or ways to make it better or more efficient are welcome! 😄

Code: New Customer Points Per Dollar = CALCULATE(ROUNDUP( SUM('SALES DETAILS'[Sales Line Sales Amount]),0), ALLEXCEPT('Sales Rep', 'Sales Rep'[Sales Rep Name]))

[heathernicole]

Here are some resources I used to help figure it out. 🙂 

• http://stackoverflow.com/questions/23835611/how-to-sum-a-column-based-on-another-column-in-dax-power...
• https://msdn.microsoft.com/en-us/library/gg492171.aspx
• https://msdn.microsoft.com/en-us/library/mt163693.aspx
• Definitive Guide to Dax (GREAT resource!) 

[Sean]

@heathernicole you are on a roll!