topic Re: Filter common values in DAX Commands and Tips

Filter common values

Notakker — Wed, 22 Mar 2023 21:42:26 GMT

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.

Re: Filter common values

Anonymous — Fri, 24 Mar 2023 02:26:28 GMT

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.