https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/parent-child-hierarchy-filtering/m-p/1388622#M25412 <P>I forgot to say that I am working in Excel hence using ISFILTERED rather than ISINSCOPE</P> Wed, 23 Sep 2020 00:34:31 GMT robinherrick 2020-09-23T00:34:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/parent-child-hierarchy-filtering/m-p/1388619#M25411 <P>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.</P><P>&nbsp;</P><P>The first measure is<BR />BrowseDepth:=ISFILTERED (Persons[Level1]) +<BR />ISFILTERED (Persons[Level2]) +<BR />ISFILTERED (Persons[Level3]) +<BR />ISFILTERED (Persons[Level4])</P><P>&nbsp;</P><P>and the second is<BR />PC Amount:=IF (<BR />MAX (Persons[NodeDepth]) &lt; [BrowseDepth],<BR />BLANK (),<BR />SUM(Sales[Amount])<BR />)</P><P>&nbsp;</P><P>The output table is the person's name and the PC Amount.</P><P>I cannot figure out how to do this by myself so any help would be much appreciated.</P> Wed, 23 Sep 2020 00:33:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/parent-child-hierarchy-filtering/m-p/1388619#M25411 robinherrick 2020-09-23T00:33:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/parent-child-hierarchy-filtering/m-p/1388622#M25412 <P>I forgot to say that I am working in Excel hence using ISFILTERED rather than ISINSCOPE</P> Wed, 23 Sep 2020 00:34:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/parent-child-hierarchy-filtering/m-p/1388622#M25412 robinherrick 2020-09-23T00:34:31Z