Hi
I'm working on a dashboard that will have a set a filters for state, city, and specialty for clients. I'm trying to get a grand total off the averages for total revenue, but I can't get the grand total right total. This is the DAX formula syntax I've been using but it doesn't give the correct grand total. The averages for each individual row is correct but the grand total isn't correct
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]))
I'm working on a dashboard that will have a set a filters for state, city, and specialty for clients. I'm trying to get a grand total off the averages for total revenue, but I can't get the grand total right total. This is the DAX formula syntax I've been using but it doesn't give the correct grand total. The averages for each individual row is correct but the grand total isn't correct
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]))
