Total not Matching as per the dax created

[harirao]

Hi All,

I am trying to create a Table & Chart, Sum of the $ value is not matching, DISTINCT of Opportunity Identifier should match with $ value.
DAX

TestValueUSD =

AVERAGEX(SUMMARIZE('Summary_SFDC','Summary_SFDC'[Opportunity Identifier]), SUMX(DISTINCT('Summary_SFDC'[Opportunity Identifier]),FIRSTNONBLANK('Summary_SFDC'[Total Opportunity Value USD Amount],0)))

in PBI getting Sum of all the $ value is $54M, when i export same data to excel it is $33M



Can you please help me fix the above dax which i have created to get correct value.

Thank you

Regards,

[Rygaard]

in Excel you get Sums in totals

in Powerbi you get the same calculation for the sum line,  so its not a Sum, its the same calculation for the last line.

Normaly you can fix this by fixing the Model, and the Hiracy on your table.

if not do an IF statement where yo check if your line is filtered like this