Forum Discussion

archieatpalmer's avatar
archieatpalmer
New Member
6 years ago

Table Export Sum (EXCEL) doesnt match Table sum

Hi,

 

I've been at this for a while now and watched many videos on why the totals are not summing correctly for this measure.

The sum in the excel spreadsheet is right, but not in the table.

 

my measure: 

Amount =
 
    (IF(SELECTEDVALUE('AR_DASHBOARD_V (UNPIVOTED)'[Grouping]) = "Total",
         SUM(AR_DASHBOARD_V[TOTAL_OUTSTANDING]),
     IF(SELECTEDVALUE('AR_DASHBOARD_V (UNPIVOTED)'[Grouping]) = "SUBDOLLARS",
         SUM(AR_DASHBOARD_V[SUBDOLLARS]),
        SUM(AR_DASHBOARD_V[PWRDOLLARS])))
    )
 
The SELECTEDVALUE is controlled by "Filter by Receivable Group" as seen below. There are no background filters.
I looked at each individual number from the table and excel, and the numbers match.
 
I don't know where to go from here.
Please help. Thanks
 
Need Help

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    Hi archieatpalmer 

    Can you share the pbix (or an abridged version thadt reproduces the issue).

    You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     

     Cheers 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    archieatpalmer 

    If you are creating a calculated column they should match. This is a typical measure total problem, you may find the explanation and solution of why the totals are different here:

    https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

    And of course, if you can provide the sample file, I think we could have a more definite solution. 

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.