Most RecentNewestMost VotedMost ViewedDAX Measure: Incorrect Total of PBI vs Excel export Hello Power BI Community, I'm facing an issue with my DAX measure Budget Balance, where the totals in Power BI visual don't match when exported the results to Excel. The row-level calculations seem fine, but the total is incorrect. Here’s my current measure trace: Due = [ParticipationAmt] - [ReceivedAmt] OpenAging = CALCULATE([Due], Event[Event Age Group] <> "Paid/Completed", REMOVEFILTERS(Event[Event Date]), Event[Event Age] > 0) FlatRatesTotal = IF(ISINSCOPE('Branch'[FPA Name]) || ISINSCOPE('Branch'[RM Name]) || ISINSCOPE('Branch'[Branch]), BLANK(), SUM('Flat Rates'[Flat Rates])) Total YTD Budget = [ActualBudgetTotal] + [FlatRatesTotal] Budget Balance = IF([Total YTD Budget] = 0, [OpenAging]*-1, [Total YTD Budget] - SUM('Transaction Detail'[Participation/Received])) Calculated Column: Participation/Received = IF(LOOKUPVALUE(Event[Event Status], Event[Event ID], 'Transaction Detail'[EVENTID])="Closed", [Received $], [Participation $]) The issue: The total for Budget Balance does not align with Excel (PBI totals are lower compared to Excel) I suspect the issue may be with SUM vs. iterating functions like SUMX or how totals are aggregating at different levels. Can anyone help identify what might be causing the incorrect total and how to fix it? Appreciate any insights! Thanks in advance! SolvedTotal incorrect Hi all, I'm new to Power BI and DAX and have bit of an issue with the DAX totals. Is anyone able to help me please? I'm expecting the total to be 15.7m like I see in Excel but in Power BI I get inflated figures showing 60.5m. Can anyone help me please with my DAX calculation?: Solved
