Forum Discussion
Slicer filtering another Slicer
Hi, good morning. I have a very simple model consting of 3 tables : Area, SubArea and Machines. Each Machine belongs to a SubArea and each SubArea belongs to an Area. I trying to creat a repo...
amitchandak
Super User
Super UserAnonymous can you share a relationship diagram?
If this is from Area ->(1-M) Sub Area ->(1-M) Machine
it should filter.
or create a measure in the Area table
A= count(Area [Area]) ,
Go to visual level filter or subarea slicer and check that A is not blank
Take a look at model:
https://1drv.ms/u/s!AmzyDwofiLHinFExd83TORK8CVq3?e=1BNpFI
It should work, I know that, but it's always showing those "ghost" results.