Forum Discussion

Roseventura's avatar
Roseventura
Icon for Responsive Resident rankResponsive Resident
8 years ago

Different Results when using Filter slicer vs Filter()

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?

 

 

 

 

Need Help

3 Replies

  • mmace1's avatar
    mmace1
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    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's avatar
      Roseventura
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

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

       

      Rose

       

      • mmace1's avatar
        mmace1
        Icon for Impactful Individual rankImpactful Individual
        8 years ago

        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.