Forum Discussion
Filter common values
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.
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.
1 Reply
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.