Forum Discussion
Bimbone
2 years agoHelper I
Filtering in visual
Hello, everyone, I'd need some help with an issue I am banging my head. As part of a larger database, I have the table WorldCup (which is connected to other tables, like Country_Numbers or Count...
PijushRoy
2 years agoCommunity Champion
Hi Bimbone
It depends on your data model. If you have perfect data model and you use Country_ID from Country_Numbers table, it will filter all of your visual.
But in your data model, looks you are using DUEL relationship in multiple table.
Please redesign your data model as DIM & FACT relationship or STAR SCHEMA model
You can create sample PBIX file (with sample non sensitive data) and share the pbix file link (google drive/dropbox/onedrive)
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.
Thanks
Pijush
Linkedin