Forum Discussion

Kopek's avatar
Kopek
Icon for Helper IV rankHelper IV
4 years ago
Solved

Dax for select All

Hey!   I want to introduce "Select All" option in a clicket slicer. I do have a list of qtrs like below. What i want to achieve is - when "Select All" is clicked all available qtrs would be visib...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Kopek ,

    Please refer to my pbix file wo see if it helps you.

    Create a new table based on the table.

    Table_copy = SUMMARIZE('Table','Table'[Quarter])

    Then put the table_copy[Quanter] into the slicer.

    Then create a measure.

    Measure =
IF (
    SELECTEDVALUE ( Table_copy[Quarter] ) = "Select All"
        && SELECTEDVALUE ( 'Table'[Quarter] ) <> "Select All",
    1,
    IF (
        SELECTEDVALUE ( 'Table'[Quarter] ) = SELECTEDVALUE ( Table_copy[Quarter] ),
        1,
        0
    )
)

    Then filter the measure.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Kopek's avatar
    Kopek
    Icon for Helper IV rankHelper IV
    4 years ago

    Unfortunately i want to use the chiclet slicer, since need to format it differently, and it does not have select all option availabale.