Hi,
I am experiencing a weird behavior when using multiple slicers in a single report, this is the situation, I have three different csv files, one containing an universe of persons with a unique ID, the second csv file is a two columns one, first column the person ID, second an score (not every person has an score). Third csv file is also a two columns person ID and number of attempts (not every person has a record in this table).
When creating an report for file 1 combined with file 2 and adding an slicer based on the score I got 8699 different persons with an score (from a total of 98k).
Similar, when creating a report for file 1 and file 3 and adding a single slicer for number of attempts I got 8699 different persons with any number of attempts.
The issue comes when combining both slicers in a single report, if I enable the SELECT ALL in both slicers, I expect to have a count of 8699, since just 8699 different persons have any score with any number of attempts, but the report is telling me 98k (the total of persons).
Now if I individually select every number in both slicers (one by one) I got the right number 8699, it seems to me that the SELECT ALL feature in the slicers also includes BLANK, however the blank option is not being displayed in the list.
Any thoughts?
