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: