Forum Discussion
Limiting Filter Options
Hi JM_nxgn
Please see the below solution.
1. Create a measure
_filter = INT( NOT ISEMPTY( Owner ) )
2. Use this measure as a filter on both sliners like below.
Second option is to create one dimension table that contains both Breed and Animal and link it to Owner on Breed ID, and this would be the best practice.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi JM_nxgn
Not sure if I understand what you need, but if you have one table with both columns in than the behaviour should be as below.
Please let me know if that is what you expecting.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Okay I think I've found the issue, just not too sure on what procedure to follow in order to fix this. Probably something to do with creation of dimension tables (which I'm not too familiar with).
So the table I mentioned in the first post was created by these three tables:
| AnimalId | Animal |
| 1 | Dog |
| 2 | Cat |
| BreedId | Breed |
| a | Chow |
| b | Corgi |
| c | German Shepherd |
| d | Siamese |
| e | Russian Blue |
| OwnerId | AnimalId | BreedId |
| 1 | 1 | c |
| 2 | 1 | a |
| 3 | 2 | d |
| 4 | 2 | e |
| 5 | 1 | a |
| 6 | 2 | d |
| 7 | 1 | b |
But then I'm using the respective AnimalName and BreedName as the filters and not their respective Id's.
Would this be a cause as to why it's not limiting the filter options? How would i fix this?
Thank you!