Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
robinherrick
New Member

parent child hierarchy filtering

I have a four level hierarchy, arranged much as per the example in F 11 17 from Chapter 11 of the Definitive Guide to DAX by Russo Marco and Ferrari Alberto. When I filter by name, it keeps the person and its parents, but I also want to keep the children of the filtered person.

 

The first measure is
BrowseDepth:=ISFILTERED (Persons[Level1]) +
ISFILTERED (Persons[Level2]) +
ISFILTERED (Persons[Level3]) +
ISFILTERED (Persons[Level4])

 

and the second is
PC Amount:=IF (
MAX (Persons[NodeDepth]) < [BrowseDepth],
BLANK (),
SUM(Sales[Amount])
)

 

The output table is the person's name and the PC Amount.

I cannot figure out how to do this by myself so any help would be much appreciated.

1 REPLY 1
robinherrick
New Member

I forgot to say that I am working in Excel hence using ISFILTERED rather than ISINSCOPE

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.