Issue with column totals

Question

I just want to sum a column total and add the column totals of all the 4 columns but Power BI is giving insane totals. I calculated it manually and it is totally different. Please help.

parry2k · Answer

Kolumam what expression are you using to sum.&nbsp;Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

kolumam · Answer

Hi&nbsp;parry2k&nbsp;&nbsp;I just want to sum a particular column. I use the below measure bit it is giving the wrong total.&nbsp;Measure = SUM(Eac-Admin)

parry2k · Answer

Kolumam seems like something is missing here, share following info:
&nbsp;
- relationship diagram if there are more than one table
- on table visual what columns/measures you had dropped on value section or if you are using other visual, share info about that

kolumam · Answer

Hi&nbsp;parry2k&nbsp;&nbsp;It is just a single table which I am fetching from SQL via direct query. There are 4 columns and a date. I just want to add a total of 4 columns. See below image. When I click on "Don't summarize", it is showing the values correctly. See the next image.When I click on the sum, it is giving the wrong totals.

kolumam · Answer

parry2k&nbsp;Do you know why?

Forum Discussion

Issue with column totals

5 Replies

Related content

Total Count in Column

Tableau to PowerBI Running Totals Issue

Use relationship total issue

Navigator Issue - Total Newbie

Power BI Date Column Issue