Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |