Simple DAX calculation

[Anonymous]

I made a DAX of the following Formula but i verified the formula using excel there is a quite a bit of difference in the results that I have obtained. Yellow Colored column is from Power BI using DAX and Grey is in excel using the formula below, but somehow the implementation is not working in DAX. 

What I am doing wrong or how to correct this error. Seems like a very simple problem?

Total Revenue = (T.CHARGES + T.XCHARGES) * T.FUNCTIONAL_AMT / T.TOTAL_CHARGES

DAX 

Total Revenue = (SUM('1.Orders (fact)'[CHARGES])+SUM('1.Orders (fact)'[XCHARGES]))* DIVIDE(SUM('1.Orders (fact)'[FUNCTIONAL_AMT]),SUM('1.Orders (fact)'[TOTAL_CHARGES]))

The Excel Workbook export

=+IFERROR((E5+F5)*D5/E5,0)

The total I get in the power BI is also hugely  different i get a total of 1,111,016 in POWER BI when I export the data into Excel it shows only 53,000. What am I doing wrong?

[FreemanZ · Accepted solution]

hi @Anonymous 

try leave out all the SUM, like:

Total Revenue = 

(('1.Orders (fact)'[CHARGES])+

('1.Orders (fact)'[XCHARGES]))* 

DIVIDE(

    ('1.Orders (fact)'[FUNCTIONAL_AMT]),

    ('1.Orders (fact)'[TOTAL_CHARGES])

)