Issue with surprising slow calculation

[masplin]

Hi. Having an issue with what i thought was a very simple table refreshing online that works fine in desktop

The table has 6 measures and performance analyzer sase over 9000ms for theDAX query.  If I delete the last measure the time drops to 4000ms

The measure that makes the differnece is simply his which just adds the 2 measures already calculated together.   I can't see why this would double the time, but maybe it starts from zero for each measure? Is there any way to cache the results so the sum is much quicker? 

Associate Gross Billing = IF([Total Associate Net Billing]+[Total Associate VAT]=0,BLANK(), [Total Associate Net Billing]+[Total Associate VAT])

I'm guessing fundamentally the issue is that for these calculations I am taking the name of an associate and having to filter multiple tables for that name anda date range to calculate various sub-measures that eventually get summed up. Sadly the data for each associate is on different tables for each task they do.  There are probably 8 tables queries for each line so is there a way to create a table of all the components and sum them without repeating the exercise for each measure,. 

for example

Total Associate Net Billing = IF([Activity Associate Cost]+[Event Associate Costs]+[Associate Exp Cost]=0,BLANK(),[Activity Associate Cost]+[Event Associate Costs]+[Associate Exp Cost])

but

Activity Associate Cost = [Activity Associate Del Cost]+[Activity Associate Exp Cost]

and

Activity Associate Del Cost = CALCULATE( SUM(Support_Package_Items[Associate Delivery Cost]),
                                    FILTER(Support_Package_Items, RELATED(Associates[Test])="N"),
                                        USERELATIONSHIP(DateTable[Date],Support_Package_Items[Start Date]))

so the 3 measures summed to get net each has 2 components and each has a similar calculate function

I can see now there is a lot of filtering going on to create the peices at the bottom of the tree and it has ot perform that to get both the net then again to get the gross. 

Any tips on how to reduce the repetition?  Do I need to move the componets up into VAR withih nthe higher measures instead of it being combiniation of multiple layers of measures. 

[amitchandak]

@masplin , change these two measure like this and check if there is any improvement

Associate Gross Billing = [Total Associate Net Billing]+[Total Associate VAT] +0

Total Associate Net Billing = [Activity Associate Cost]+[Event Associate Costs]+[Associate Exp Cost] +0

[masplin]

still 9700ms