Weighted Average is correct, but recalcs when OrderID context is applied

[DataUsurper]

Lo All,

I have a correct measure for my weighted average but when I attempt to related our orders w/ a delta calc that wAverage recalcs per order. How can I maintain the static weighted average when applying OrderID Context (see images):

wAvg_Actual = CALCULATE(SUMX(TBLDATA,((TBLDATA[QTY]*TBLDATA[BILL_DAYS])/7)*TBLDATA[Actual_Price.Disc])/SUMX(TBLDATA,((TBLDATA[BILL_DAYS]/7)*TBLDATA[QTY])),TBLDATA[Actual_Price.Disc]>0)

Thank you kindly

[DataUsurper · Accepted solution]

Was able to get this to work using "ALLExcept" but I also need a secondary filter for when a field is > 0

wAvg_Actual = CALCULATE(SUMX(TBLDATA,((TBLDATA[QTY]*TBLDATA[BILL_DAYS])/7)*TBLDATA[Actual_Price.Disc])/SUMX(TBLDATA,((TBLDATA[BILL_DAYS]/7)*TBLDATA[QTY])),ALLEXCEPT(TBLDATA,TBLDATA[E.CODE]))