Hi

I'm trying to get a grand total off the averages for total revenue, but I can't get the right total. This is the DAX formula syntax I've been using but it doesn't give the correct grand total.

Average Break-Even 3rd Party Billings:=VAR BE3rdParyBill = AVERAGEX(VALUES('Financial Analysis Break-Evens'),[BE_3rd_Party_Billings__c]) VAR BETotAvg3rdParty = SUMMARIZE('Financial Analysis Break-Evens',"Amount",BE3rdParyBill) Return IF(HASONEVALUE(Account[BillingState]),BE3rdParyBill,SUMX(BETotAvg3rdParty,[Amount]))