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 ...
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.