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

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.