Increase virtual column sum speed

[kbowling33]

Is there a better formula to use to sum the data of a different table.  I am getting about a 5 second lag.

Sum(select(table[column], variable)

Thanks

[TeeSee1]

I do not think It is a matter of formula that speeds up recalculation.

What you can do is to force a change in a field of the row that has the SUM formula whenever you update your source table. (use Data: execute an action on a set of rows on the source table to call an action on the result table to update some column in the result table.)

Hope this does the trick for you.

[scott192]

If the record you are summing for has a field [Related Things], then you can sum a column in those related things without having to perform a Select on the table as a whole.

For instance, I have a table called Customers and Orders.  The Orders Table has many items that have been ordered by individual customers.  The Customers table has a relation to the Orders table and shows in the Customers tables as [Related Orders].

Now, in your example you would say SUM(SELECT(Orders[OrderValue],[CustomerID] = [_THISROW].[CustomerID])) and you would get your sum.  However, the SELECT has already been done for you in the [Related Orders] field.  So, you would just use SUM([Related Orders][OrderValue]) to get the sum of all orders for that customer.

[kbowling33]

Thanks for the tip! I've used ref tables many times before, but never knew
the sum function would work faster that way.