Filter common values

[Notakker]

My data:

My goal:

I'm trying to build a graph with Users and common values between them (at least two). Example, when I try to build my graph, thats what I have:

But I want to eliminate node with only one connection:

Up to here, I can achieve using agreggation and filtering count > 1. But when I try to filter by two or more Users, i'm not able to keep the same dynamic, because the number of connections changes.

[Anonymous · Accepted solution]

Hi @Notakker 

You can refer to the following measure

Measure = IF(COUNTROWS(FILTER(ALLSELECTED('Table'),[Related]=SELECTEDVALUE('Table'[Related])))>1,1,0)

Then put the measure to the visual filter

It can work

Best Regards!

Yolo Zhu

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