Multi Select Slicer

[Selwynster]

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 an 'AND' result, not 'OR' (which is what the slicer currently gives me).

So i need one date Attribute result, that has a 2, 6 and 9 Value.

Hope i am explaining myself correctly. 

[v-jiascu-msft · Accepted solution]

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 )

Best Regards,

Dale

[Anonymous]

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]

Hi @Anonymous,

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

Best Regards,

[Anonymous]

Thanks. Will do.

[Selwynster]

Wow, this works amazingly.

Thanks 

[quentin_vigne]

Hi @Selwynster

Did you try using 3 slicers instead of one ? 

Because when you select multiples values from a slicer it will display everything that has one the three at least 

Else can you post here a sample of your data so that we try to solve the problem ?

- Quentin

[Selwynster]

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.

[quentin_vigne]

@Selwynster

In the sample of data you provided me there is only distinct attribute so I can't try my soluce on this data 

- Quentin

[Selwynster]

@quentin_vigne, Here below some better data:

Attribute	Value
9/9/2016	2
9/9/2016	18
9/9/2016	35
9/9/2016	37
9/9/2014	2
9/9/2014	4
9/9/2014	18
9/9/2014	19
9/9/2014	29
9/9/2011	10
9/9/2011	18
9/9/2011	23
9/9/2011	36
9/9/2011	40
9/8/2017	34
9/8/2017	6
9/8/2017	7
9/8/2017	42
9/8/2015	1
9/8/2015	12
9/8/2015	13
9/8/2015	14
9/7/2012	9
9/7/2012	14
9/7/2012	17
9/7/2012	34
9/7/2012	41
9/7/2010	3
9/7/2010	25
9/7/2010	37
9/7/2010	42
9/7/2010	44
9/6/2016	4
9/6/2016	18
9/6/2016	39
9/6/2016	43
9/6/2013	15
9/6/2013	16
9/6/2013	24
9/6/2013	29
9/6/2013	40
9/6/2011	1
9/6/2011	2
9/6/2011	5
9/6/2011	30
9/6/2011	40
9/5/2017	14
9/5/2017	2
9/5/2017	32
9/5/2017	13
9/5/2014	1
9/5/2014	8
9/5/2014	24
9/5/2014	33
9/5/2014	43
9/4/2015	1
9/4/2015	25
9/4/2015	29
9/4/2015	43
9/4/2012	6
9/4/2012	15
9/4/2012	19
9/4/2012	30
9/4/2012	45
9/30/2016	5
9/30/2016	15
9/30/2016	16
9/30/2016	25
9/30/2014	18
9/30/2014	27
9/30/2014	37
9/30/2014	39
9/30/2014	41
9/30/2011	11
9/30/2011	21
9/30/2011	24
9/30/2011	28
9/30/2011	35
9/3/2013	17
9/3/2013	28
9/3/2013	32
9/3/2013	33
9/3/2013	36
9/3/2010	12
9/3/2010	17
9/3/2010	37
9/3/2010	41
9/3/2010	43
9/29/2017	42
9/29/2017	39
9/29/2017	26
9/29/2017	32
9/29/2015	10
9/29/2015	11
9/29/2015	12
9/29/2015	24
9/28/2012	1
9/28/2012	6
9/28/2012	7
9/28/2012	40
9/28/2012	41
9/28/2010	1
9/28/2010	3
9/28/2010	4
9/28/2010	5
9/28/2010	40
9/27/2016	3
9/27/2016	11
9/27/2016	34
9/27/2016	37
9/27/2013	6
9/27/2013	13
9/27/2013	21
9/27/2013	28
9/27/2013	31
9/27/2011	1
9/27/2011	7
9/27/2011	8
9/27/2011	22
9/27/2011	40
9/26/2017	45
9/26/2017	17
9/26/2017	33
9/26/2017	9
9/26/2014	1
9/26/2014	3
9/26/2014	6
9/26/2014	34
9/26/2014	37
9/25/2015	14
9/25/2015	20
9/25/2015	21
9/25/2015	26
9/25/2012	2
9/25/2012	28
9/25/2012	32
9/25/2012	34
9/25/2012	45
9/24/2013	6
9/24/2013	23
9/24/2013	25
9/24/2013	26
9/24/2013	43
9/24/2010	1
9/24/2010	5
9/24/2010	10
9/24/2010	16
9/24/2010	19
9/23/2016	3
9/23/2016	11
9/23/2016	30
9/23/2016	32
9/23/2014	7
9/23/2014	10
9/23/2014	21
9/23/2014	22
9/23/2014	34
9/23/2011	5
9/23/2011	22
9/23/2011	24
9/23/2011	25
9/23/2011	27
9/22/2017	4
9/22/2017	12
9/22/2017	28
9/22/2017	30
9/22/2015	2
9/22/2015	21
9/22/2015	22
9/22/2015	25
9/21/2012	13
9/21/2012	16
9/21/2012	24
9/21/2012	39
9/21/2012	43
9/21/2010	31
9/21/2010	33
9/21/2010	36
9/21/2010	40
9/21/2010	42
9/20/2016	2
9/20/2016	18
9/20/2016	29
9/20/2016	32
9/20/2013	15
9/20/2013	22
9/20/2013	29
9/20/2013	30
9/20/2013	38
9/20/2011	8
9/20/2011	10
9/20/2011	23
9/20/2011	31
9/20/2011	38
9/2/2016	20
9/2/2016	23
9/2/2016	30
9/2/2016	38
9/2/2014	11
9/2/2014	21
9/2/2014	36
9/2/2014	39
9/2/2014	44
9/2/2011	15
9/2/2011	25
9/2/2011	34
9/2/2011	43
9/2/2011	45
9/19/2017	39
9/19/2017	22
9/19/2017	15
9/19/2017	25
9/19/2014	9
9/19/2014	13
9/19/2014	25
9/19/2014	28
9/19/2014	34
9/18/2015	5
9/18/2015	17
9/18/2015	25
9/18/2015	40
9/18/2012	1
9/18/2012	27
9/18/2012	37
9/18/2012	40
9/18/2012	42
9/17/2013	11
9/17/2013	18
9/17/2013	22
9/17/2013	27
9/17/2013	29
9/17/2010	2
9/17/2010	19
9/17/2010	28
9/17/2010	42
9/17/2010	44
9/16/2016	1
9/16/2016	12
9/16/2016	33
9/16/2016	34
9/16/2014	7
9/16/2014	12
9/16/2014	28
9/16/2014	43

[quentin_vigne]

Hi @Selwynster

Is there a maximum of selected number ? If it's 3 or less I have a solution, else I need to keep thinking about it

- Quentin

[quentin_vigne]

@Selwynster

Perhaps if you don't enable interactions between the 3 slicers it will work 

On this guide you will find how to send sample of data

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Copy and paste your table from the data table here so that I can copy them right into my pbi desktop