Different Results when using Filter slicer vs Filter()

[Roseventura]

Anyone know why my totals would differ when I use a filter slicer to select a Branch (for instance) versus using a calculate function with a Filter() function to filter out that same Branch?

For instance, say I have these Branches:  East, West, South, North

I have a slicer that allows me to select either one or several of these branches.  Let's say I select EAST.  My Sales total will show as $77,364.28.

However, if I use this measure:  Total EAST Sales = calculate([total sales], filter('UsageDetails', 'UsageDetails'[Branch]="EAST")), the total comes to $75,292.13.

Any ideas?

[mmace1]

Is your slicer based on the same table your CALCLUATE function is using?  I.e, is your slicer based on the branch info in the 'UsageDetails' table? 

[Roseventura]

Yes.  So far in this report I only have one fact table.  No lookup tables.  All fields are in the UsageDetails table.

Rose

[mmace1]

Is the data small enough that you can copy to Excel to manually filter & see which of the 2 answers is correct? 

Not that that would answer *why*, but just as a step.