Forum Discussion
Checking if element belongs in same groups as a selected one.
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.