Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
9 years ago
Solved

Wrong totals, different than export

Hi.  I have a table in Power BI, that looks pretty good. See pic below.  The problem is on export, the totals in excel are different.  See excel photo at bottom.  So basically the excel document is r...
General Comment
  • Unicorn_Tech's avatar
    Unicorn_Tech
    9 years ago

    I actuall was told by our developer that the problem had to do with summarizing LOV values.   We made this change, and the problem resolved itself. 

  • Unicorn_Tech's avatar
    Unicorn_Tech
    7 years ago

    Hello, I apologize for the delay.  What solved it for us was a simple rounding - surrounding the formula calculating all the numbers with the round formula, to two decimal points.)  This allowed all the sums to add up correctly.

dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
9 years ago

Hi 

 

This is possibly due to filtering and summation of your data when there is a relation build between tables.

 

Please create your measure as follows to get the correct values.

 

IF(HASONEVALUE(TableName[FieldName]),[Total Amount field],SUMX(VALUES(TableName[FieldName]),[Total Amount field])).

 

If you share some sample data i can do it for you.

  • Igotzepowerbi's avatar
    Igotzepowerbi
    Frequent Visitor
    3 years ago

    Could you help me write your formula? I am having the exact some problem where my totals in PBI do not match the excel export.