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.
Go to Solution.
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.