Finding common

Question

I would like to show on a table visual common items between groups selected in a drop down filter.&nbsp;The data table looks like so.Group&nbsp; &nbsp; &nbsp; &nbsp;ItemA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6E.g is A and B are selected , the table shows 2 and 3.&nbsp;Can someone share their insight.&nbsp;Thanks in advance.&nbsp;&nbsp;

parry2k · Accepted Answer

Anonymous&nbsp; I have a similar solution, check my video here, tweak it as you see fit&nbsp;https://youtu.be/jfjCzOOo_bo
&nbsp;

✨ Follow us on LinkedIn and&nbsp;&nbsp;to our YouTube channel 
&nbsp;
Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc
&nbsp;
I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation! 
&nbsp;
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Forum Discussion

Finding common

✨ Follow us on LinkedIn and to our YouTube channel

1 Reply

✨ Follow us on LinkedIn and to our YouTube channel

Related content

NATURALLEFTOUTERJOIN not finding common join columns

Powerbi Find most common value

Find Commonalities

NATURALLEFTOUTERJOIN not finding common join columns

Finding Common Values Between Two Columns