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

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

Hi  quentin_vigne

Using 3 slicers does not work because when i select 1 option in the first slicer, it limits the other slicers immediately.

The data i have is basically what is seen in the first table (on the left of the image.)

Sorry, i am new here, so i not sure how to send the entire dataset.

The end result i need would look like:

1/2/2016      2

1/2/2016      6

1/2/2016      9

(if that date has all the Values)

I am not interested in dates that only have one of the 3 Values.