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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (15,538)