Forum Discussion
Solved
Filtering Data challenge
Hello community! I have a challenge i can't solve alone. I have a database like you see on the picture, and i should create a filter button for the Location, which filters for all contracts from t...
use a measure as a visual filter.
lbendlin
Super User
Super Useruse a measure as a visual filter.
ArwaAldoudSuper User
Super UserHi lbendlin
I actually tried a similar DAX approach, but the main difference is that you separated the Location into its own table that’s a smart move to simplify the filtering logic.
Thanks for sharing
- lbendlin
This is a mandatory design, not a "smart move to simplify". The request can only be fulfilled with disconnected tables.
- ArwaAldoud
I’m fully aware that a disconnected table is the typical design pattern — my approach was more of an experiment to validate if it could work directly within the main table.
It’s interesting how exploring such variations helps clarify why certain designs are “mandatory.”