Trying to get the Sum of a column and its wrong

[Anonymous]

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.

@summarize

[AlexisOlson]

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,

[Anonymous]

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

[Anonymous]

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

[AlexisOlson]

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

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