topic Re: How to list all members of a family (or group) filtering by any of its members in DAX Commands and Tips

How to list all members of a family (or group) filtering by any of its members

nathalylopez — Thu, 30 Jun 2022 16:17:12 GMT

Hi,

I have the following data, where the member of the Families A and B are listed.

I want to show the members of the a family when I select a one of its members filtering by PersonId field.

For Example:

If I select the PersonId 1728364.

I want to show the members of the A family as it's shown in the following image:

I think this could be solved with dax, but I don't how, so I hope you could help me.

Thanks.

Re: How to list all members of a family (or group) filtering by any of its members

Jihwan_Kim — Thu, 30 Jun 2022 17:34:24 GMT

Hi,

One of ways to solve this is to create disconnected slicer table like below.

Please check the below picture and the attached pbix file.

It is for creating a measure.

PersonID Measure: = VAR _selectedfamily = SUMMARIZE ( FILTER ( ALL ( Data ), Data[PersonID] IN VALUES ( Slicer[PersonID] ) ), Data[FamilyID] ) RETURN IF ( HASONEVALUE ( Data[Name] ), CALCULATE ( MAX ( Data[PersonID] ), Data[FamilyID] = _selectedfamily ) )

Re: How to list all members of a family (or group) filtering by any of its members

nathalylopez — Fri, 01 Jul 2022 04:54:11 GMT

Jihwan_Kim, thanks a lot for your help.

Re: How to list all members of a family (or group) filtering by any of its members

TRADER083 — Mon, 30 Jun 2025 13:50:09 GMT

Hi Jihwan_Kim, how would you change this if a Name can belong to multiple FamilyID?