Filter dynamically based on mutliple values

[MarijeB]

Hi,

I'm new to PowerBI, but I managed to create my first report. There's only one thing I can't figure out, maybe someone here is willing to help me.

I'm using a dabase to manage upcoming events. All events have an unique ID. Some events are unique and some are identical. Those latter are defined in two columns: Identical ( = true) and CombinedID (= an ID used for all events that are identical).

I use multiple slicers to filter for instance on location, starting time, sort of event and unique ID.

This is just a basic example:

ID	Date	Starting time	Event	Duration	Location	Identical	CombinedID
T3.5-1	10-03-2025	09:00	Event T3.5-1	120	E	true	T3.5-1
T3.5-2	11-03-2025	09:00	Event T3.5-2	120	L	true	T3.5-1
T3.5-10	10-03-2025	09:00	Event T3.5-10	120	A	false	T3.5-1
T3.5-28	13-03-2025	12:00	Event T3.5-28	120	L
T3.5-29	10-03-2025	12:00	Event T3.5-29	90	G
T3.5-30	14-03-2025	12:00	Event T3.5-30	120	E
T3.5-31	10-03-2025	12:00	Event T3.5-31	90	A	true	T3.5-31
T3.5-32	10-03-2025	15:00	Event T3.5-32	90	G	true	T3.5-31
T3.5-33	14-03-2025	15:00	Event T3.5-33	120	L	true	T3.5-33
T3.5-34	10-03-2025	15:00	Event T3.5-34	120	E	true	T3.5-33
T3.5-35	10-03-2025	15:00	Event T3.5-35	150	L

Now, I'd like to show all unique ID's in a slicer, and if you click on any of ID's that is in a 'group' with combinedID's, to show the other events as well. So, the conditions would be: if Identical is true for the selected event, then return all rows from the combinedID. 
I tried using a Pivot table and it works sort of for the first ID in the 'group', but not for any of the other ID's. So, if I click T3.5-31, it returns both T3.5-31 and T3.5-32, but if I click on T3.5-32, it only returns T3.5-32.

I tried searching and learned a lot, but I'm not able to apply any of the sufggestions to my case. Any help would be appreciated.

[v-sdhruv]

Hi @MarijeB ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @MarijeB ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @MarijeB ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv · Accepted solution]

Hi @MarijeB ,

In SharePoint Lists, sometimes empty fields are a bit tricky (Blank vs Null), but not an issue.

Create a calculated column-

NormalizedGroupID =
IF(
ISBLANK([CombinedID]),
[ID],
[CombinedID]
)

If CombinedID is blank → use the ID itself (it's a unique event, not grouped).

If CombinedID is filled → use the CombinedID (the common group ID for identical events).

Then, you set up your slicer based on this NormalizedGroupID, not the original ID!
Create a slicer visual and use NormalizedGroupID.

Show other data (event info, time, location, etc.) based on this filter.

Now, if you click any event (whether original or identical), it will always show all events that belong to the same group!

Hope this helps!

If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[MarijeB]

Hi @v-sdhruv , I'm really sorry for the late reply, but I've been very busy lately.

You are referring to the sharepoint list, but it's not administred by me and the admin prefers not to add any more columns.

My co-workers learned to work-around it, so it's not really an urgent issue anymore. 

[Anonymous]

Hi @MarijeB ,

Based on the information, creating the new table with unique ID column.

Then, try using the following DAX formula and drag the measure to the Filters pane.

Measure = 
VAR _selected = SELECTEDVALUE('Table ID'[ID])
var _comnined = CALCULATE(MAX('Table'[CombinedID]), FILTER(ALL('Table'), 'Table'[ID] = _selected))
RETURN
IF(SELECTEDVALUE('Table'[Identical]) = "TRUE" && SELECTEDVALUE('Table'[CombinedID]) = _comnined, 1, 0)

The slicer filtering result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MarijeB]

Hi @Anonymous , stll no luck. I'm probably doing something wrong.

Whatever I try, any visual I apply the measure to turns blanc. Database- and columnnames and parameters are correct, I checked.

First, I tried adding the measure to the new table I created for the ID, and when that didn't work to the alreay existing database. I also tried to apply the measure filter on the table visual. 

Does it make a difference my source is a Sharepoint-list?

[MarijeB]

Hey @Akash_Varuna , thanks for the quick reply 🙂

Unfortunately, I already tried this option and it's not exactly what I want. The point is that I want to be able to select any unique ID in the slicer, regardless whether it is in a group or not. With this calculation it only shows the unique ID if there's no group, otherwise the group id.

Do you think it's possible?

[Akash_Varuna]

Hi @MarijeB You will have to use a calculated column for this could you please try these 
Create a calculated column in your table to handle the filtering logic:

FilterGroup = 
IF(
    'Table'[Identical] = TRUE(),
    'Table'[CombinedID],
    'Table'[ID]
)

Add the new FilterGroup column to a slicer in your report. It will display all unique IDs or groups.

This will do the dynamic filtering of all rows based on CombinedId Or Unique ID when an Id is selected
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance