Forum Discussion

ThomasDay's avatar
ThomasDay
Impactful Individual
10 years ago
Solved

Slicer Select All Weirdness

Hello Fellow Dax'ers,   I'm very surprised at the behavior of "Select All" within a slicer.  Here's an example: Build a slicer with Single Select off, Select All on. Cross filter this slicer so t...
General Comment
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi MbProg,

     

    According to your description, the Select All feature is enabled for the slicer. When you check multiple individual values in the slicer, the card will display the correct row count values. But if you select all values by checking Select All option, the card displays wrong values, right?

    Below is my test sample:

     

    1. Create a simple table with duplicate records.(Test4 has 4 records, others has one)

     

    1. Create the slicer and the measure.

     

    Measure: Count of Row = COUNTROWS(Test).

    Result:

    1. Choose the ‘select all’.

     

    In summary, the slicer shows the distinct value of column(eg: Name) you placed in the slicer. Maybe some duplicate records are in your table(eg: Test 4), though you choose the 'select all', it will count rows for all records which are related to checked slicer values.

     

    In addition, if you want to get the distinct value of the row, you can try to use below formula:

     

    1. Count of Row = COUNTROWS(DISTINCT(Test[Name]))
    2. Count of Row = COUNTROWS(VALUES(Test[Name]))

     

     

    Regards,

    Xiaoxin Sheng

AndyTrezise's avatar
AndyTrezise
Advocate IV
8 years ago

I couldn't get the standard slicers to function the way I needed them to so I switched tact.

 

I now use the hierarchy slicer for my 'child' slicer which works much better and gets around the 'select all' problem

 

lushd's avatar
lushd
Frequent Visitor
5 years ago

Adding my voice to the list as I am having the same issue, unfortunately a hirarchy slicer won't work for my needs either. Incredible that there has been no improvement in four years, it would be so easy for microsoft to add a toggle switch for "applies to all", "applies to shown" right next to where you enable the select all button. 

Has anyone come up with another workaround for this?