Forum Discussion

Selwynster's avatar
Selwynster
Icon for Helper II rankHelper II
8 years ago
Solved

Multi Select Slicer

  I have a image below with a table (left) with 2 columns, and a slicer on the right. Am i able to (using the slicer), find the date (Attribute) where ALL conditions are met? In SQL terms, i need ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Selwynster,

     

    Please try a measure like below.

    Measure =
VAR actualAmount =
    CALCULATE ( DISTINCTCOUNT ( Table1[Value] ), ALLSELECTED ( Table1[Value] ) )
VAR selectedValues =
    CALCULATE (
        DISTINCTCOUNT ( Table1[Value] ),
        ALLSELECTED ( Table1[Value] ),
        ALL ( Table1[Attribute] )
    )
RETURN
    IF ( actualAmount = selectedValues, 1, 0 )

    Multi_Select_Slicer

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Selwynster,

 

Please try a measure like below.

Measure =
VAR actualAmount =
    CALCULATE ( DISTINCTCOUNT ( Table1[Value] ), ALLSELECTED ( Table1[Value] ) )
VAR selectedValues =
    CALCULATE (
        DISTINCTCOUNT ( Table1[Value] ),
        ALLSELECTED ( Table1[Value] ),
        ALL ( Table1[Attribute] )
    )
RETURN
    IF ( actualAmount = selectedValues, 1, 0 )

Multi_Select_Slicer

 

Best Regards,

Dale

  • Selwynster's avatar
    Selwynster
    Icon for Helper II rankHelper II
    8 years ago

    Wow, this works amazingly.

    Thanks :smileyhappy:

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-jiascu-msft,

    I have a silmilar issue, I tried the DAX you provided in this post but did not work for me. I have a map connected to the data and when I make a multiple selection, I want the selections made to display using AND feature and pop up in the map. Also I want the list of those to be displayed in a table. And the map color to be changed based on the filter selection combination (different color for different combination). I appreciate your support on this. Thank you.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous,

       

      I would suggest you create a new post in this forum. It looks like a different scenario.

       

       

      Best Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks. Will do.