Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Trying to get the Sum of a column and its wrong

Hi PBI community - I feel that this will be a simple fix but I am trying to get the total sum of a column in my table but PBI is summarzing the data and it is showing way higher than I believe the true value to be when I export the table into excel.




The card is showing the higer amount and when I do the sum in excel it shows the correct amount of 380. Please help me fix this, using a SUM measure isn't working and it's not allowing me to select 'don't summarize' in the fields.







Super User
Super User

Without any additional filter context, it's summing the entire Def_Rev column. For example, it looks like you have dates as one of your table columns, so it's summing over all of the dates rather than, say, just the latest date.


Without seeing the underlying data and why the correct answer should be 380, it's hard to tell exactly what the issue is but I suspect it's something like I mentioned above,

Also I downloaded the table in excel again and the total from power bi is different than the sum I calculated in excel.




Thanks, how would I filter it to be just the latest date?

You can either use a date filter/slicer or write a measure like this:

Latest_Def_Rev =
VAR _MaxDate = MAX ( Table1[Date] )
    CALCULATE ( SUM ( Table1[Def_Rev] ), Table1[Date] = _MaxDate )

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors