Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Group Total at Underlying Line Level

Hi,    I have two tables with the following columns: Table1:Company, Account Number Table2:Account Number, Order, Amount (Order Amount)   There can be multiple Account Numbers per Company   I...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Ashish, 

 

While i cant post my actual file (confidentiality) i recreated the tables and data using dummy information and got the same issues. The file can be found here Google Drive Shared File

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

The measure should be this

 

=CALCULATE([TOtal Amount],ALL(Orders[Order]),ALL(Accounts[AccountNumber]))

 

When i try it, i get an out of memory error box.  I dragged Company from the Company_Total Table, Account Number from the Accounts Table.

 

Total Amount = SUM(Orders[Amount])

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Ashish, 

     

    Thanks, but I get an error also, so that is not a viable option.

     

    I was able to find a solution by adding this measure to the Accounts table instead of the Orders table

    =CALCULATE(SUM('Order'[Amount]),ALLEXCEPT('Account','Account'[Company]))

     

    For now this seems to be working for what I need (Ranking by Company amount including all orders), however I will need to watch to make sure that additional filters dont affect it.