Forum Discussion
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 ...
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?
Yes. So far in this report I only have one fact table. No lookup tables. All fields are in the UsageDetails table.
Rose
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.
