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 thanks for that, but it's not exactly what i need!

 

I use qtrs as a matrix headers, so in this case i would need to have a list of all availabale qtrs when select all is hit, whereas when only one qtr is selected i want to see only this particular enrty in the matrix.

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

    Kopek like this?

    Look at the matrix on the left

    • 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 :))