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

SpartaBI  Like this:

 

 

When Selec All, all available qtrs should be visible in the table/ matrix - cannot figure out this part of measure.

 


Othrwise only whatever is selected should be visible:

 

 

 

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Kopek I think it's exactly what I showed you 🙂

Check it out in the file I shared, just create that additional matrix.
I updated the file there. Downlaod it again:
Dax for select All.pbix
Appreciate your kudos :))