locked
Efficiency in power pivot RRS feed

  • Question

  • Hello. I'm summing up values in the lookup table by using calculate. 

    For example, get the total sales for all customers. Sales is a couple of tables deep from customers. Is there a more efficient way of doing this other than calculated columns? Thanks. 

    =calculate(SUM(Invoices[IV Total Adjusted Gross Amount]),Invoices[IV Status]="Paid")

    Tuesday, October 25, 2016 5:18 PM

Answers

  • Hi AlexMartini,

    If you don’t need to add a new value for each row to a table, please use measure. If you want to keep the size of your workbook to a minimum and maximize its performance, create as many of your calculations as measures as possible. In many cases, all of your calculations can be measures, significantly reducing workbook size and speeding up refresh time.

    Please create a measure and a new pivot table.

    new measure:=calculate(SUM(Invoices[IV Total Adjusted Gross Amount]),Invoices[IV Status]="Paid")

    Best Regards,
    Angelia

    MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:MSDNFSF@microsoft.com">MSDNFSF@microsoft.com</a>.


    Wednesday, October 26, 2016 10:01 AM