Table Export Sum (EXCEL) doesnt match Table sum

[archieatpalmer]

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

[Anonymous]

@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.

[AlB]

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