Choose multiple points from dropdown and only get results that have the multi choice return

[datadelta]

I'm trying to use a dropdown to choose more than one item and get my results only to reflect those that have the multi items.  Right now, I still get anyone that has either chosen.  I assume I need to make the multi select an "and" rather than an "or".

I've never done that but if there is a way to make that happen or if there is a better way, I'm asking for it.

Thanks!

[Anonymous · Accepted solution]

Hi @datadelta ,

According to your statement, I think your requirement is that you want the slicer to work with "and" logic.

Here I create a sample to have a test.

By default, if I select R2 and R3, it will show three results, but we only need A and B as result due to they both have R2 and R3 at the same time.

Firstly, you need to create an Dimtable for slicer. Then create the relationship between two tables.

Measure:

And logic = 
VAR _COUNT1 = COUNT(DimRegion[Region])
VAR _COUNT2 = COUNT('Table'[Value])
RETURN
IF(_COUNT1 = _COUNT2,1,0)

Add this measure into visual level filter and set it to show items when value =1.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[datadelta]

Hello.  Upon further review this is not bringing back the isolated items.  I also looked at your results and the numbers don't seem to be reflecting the accurate totals.  It's isolating them but the totals aren't correct from what I can see.  When I used your formula, it still returns anyone that has one or the other, not one AND the other.  

Any thoughts?  Thanks again.

[jgeddes]

If you are looking for a solution that differs from the CTRL + click function of a dropdown slicer then could you share some sample data and your desired outcome?