Forum Discussion
Helper IIMulti Select Slicer
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
Solution SageHi 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
SelwynsterUsing 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
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
- quentin_vigne
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