Forum Discussion
Checking if element belongs in same groups as a selected one.
I edited the post, making it very general but explaining better the problem I have.
Thanks for bearing with me!
Super Userso we have two tables.
one contains event name and description. event name is unique
Event 1 | Description 1
Event 2 | Description 2
Event 3 | Description 3
the other table contains event name and goupnum
| Event Name | Group Num |
| Event 1 | 1 |
| Event 2 | 1 |
| Event 3 | 2 |
| Event 4 | 2 |
| Event 5 | 1 |
| Event 5 | 2 |
when we select description, you want to display event name.
The name is from which table?
The slicer I already have works on the first table.
The table visual I have already does not feature the event name, but instead shows a list of the associated descriptions as the row headers.
All the other data about the events comes from a third table towards which the first one has another one-to-many relationship.I have managed to obtain the right list of Related Events using this function:
RelatedEventsList = VAR SelectedEvent = SELECTEDVALUE(CURRENT_EVENTS_2[Event Name]) VAR SelectedGroups = CALCULATETABLE( VALUES(EVENT_GROUPS[GROUP_NUM]), CURRENT_EVENTS[Event Name] = SelectedEvent ) VAR RelatedEvents = FILTER(ALL(EVENT_GROUPS), EVENT_GROUPS[GROUP_NUM] in SelectedGroups) RETURN CONCATENATEX( RelatedEvents, EVENT_GROUPS[EVENT_NAME], ", " )In which CURRENT_EVENTS_2 is a disconnected table created using:
CURRENT_EVENTS_2 = SUMMARIZE( CURRENT_EVENTS, CURRENT_EVENTS[Strike Name], CURRENT_EVENTS[Short Description], CURRENT_EVENTS[Activation] ), but there are 3 problems:
- The Events with a double entry in EVENT_GROUPS show up twice in the list.
- I have no idea how to use this for a Measure that would check if the other events belong to the same group(s).
- It uses another slicer based on CURRENT_EVENTS_2 to select the event, which is something I cannot have on the dashboard.