Forum Discussion
Advanced filter options from different source.
Hi Greg_Deckler , sorry, no I didn't create a slicer for Event. Events is the table I'm analysing. I want to see events for the Customer X, events of the country Y, events with critical severity, events in the area Zone 1, etc. Events is the main table, EventID would be de PrimaryKey.
farina_dj Is your relationship bi-directional?
Greg_Deckler, No It's one EventID that can have many Areas related so a 1-N in the relationship between Event-Area.
Events has many others relationships with other tables, but just 1-1, only in this case of Area that the same EventID can happen in more than one Area.
Area has just this relation with Events.
farina_dj Can you make it bi-directional or no? That would solve the issue so that Areas can filter Events
Greg_Deckler , sorry I think I didn't understand before, The table Areas does filter the Events, yes.
If I do a regular relation between Events and Areas I does work, and the filter get like this:And it filters by Areas. If I select Zone 2 it shows me only events of the Zone 2.
But the problem is the events that happens in Zone 1 and Zone 2 are being counted twice. Which means that if I don't apply any filter, the number of events is wrong, because the relation with Areas brings a cartesian plane.
That's the why I tried to produce another table AreasConcatenated that groups the same EventID and concatenates the areas to have a 1-1 relation. So the row becomes EventID = "x1", Area = "Zone 1, Zone 2".
But then it brakes the filter, because it becomes:What I'm trying to reach is a filter that only shows one option for each Area, but in a way that doesn't duplicate the event records if I don't filter.