topic Re: Power bi total column totals not adding up in excel extract in DAX Commands and Tips

Power bi total column totals not adding up in excel extract

Sunila — Fri, 02 Feb 2024 12:16:44 GMT

Hi,

We are currently dealing with a situation where I have published the report in Power BI services. However, when users export the data to Excel, the sum of totals in Excel doesn't align with the reported values in Power BI. Specifically, the table export sum in Excel doesn't match the sum of the columns in Power BI, strangely for only a few columns. Highly appreciate any assitance on this issue.

Re: Power bi total column totals not adding up in excel extract

lbendlin — Sat, 03 Feb 2024 02:04:31 GMT

Please provide more details. Are you using Analyze in Excel, or export? If export, which variation? Are these columns or measures?

Re: Power bi total column totals not adding up in excel extract

Sona2023 — Sat, 03 Feb 2024 02:09:22 GMT

Export to Excel. These are all measures.

Re: Power bi total column totals not adding up in excel extract

lbendlin — Sat, 03 Feb 2024 03:20:10 GMT

Which export to Excel? Legacy, or with live connection?

Re: Power bi total column totals not adding up in excel extract

Sona2023 — Sat, 03 Feb 2024 03:25:09 GMT

Report is having an import mode and ingesting the data from D365 F&0. All the measures are dynamically calculating the amount based on the selected start date and end date.

Re: Power bi total column totals not adding up in excel extract

lbendlin — Sat, 03 Feb 2024 03:31:36 GMT

I am talking about this option

Re: Power bi total column totals not adding up in excel extract

Sona2023 — Sat, 03 Feb 2024 03:33:59 GMT

Oh, we are using Data with current layout, the very first option 🙂

Re: Power bi total column totals not adding up in excel extract

lbendlin — Sat, 03 Feb 2024 03:38:44 GMT

that will convert measures into static values. I'd recommend you try one of the other options.