Measure calculating differently in excel than it is in PowerBI

[ruthhacche]

I have a measure in PowerBI

Fixedrate = DIVIDE(sumx ( MENTORAccount, MENTORAccount[FIXEDCOSTS] * [SF Gross Sale]), [GrossSaleAll]). SpentTotal is simply the sum of DirectxTotalCost and FixedRate.

For just one line of data it shows correctly in PowerBI:

But if I GetData into excel the FixedRate measure and SpentTotal change for this single line of Data.

I have doublechecked the source of the BIdataset and re-published/refreshed etc - I am just looking for some ideas where to begin to look for a reason.

 

[ruthhacche]

Best way to solve a problem is to ask mr excel. I have solved it myself. A bad link.