Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
I forgot to say that I am working in Excel hence using ISFILTERED rather than ISINSCOPE
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |