The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
20 | |
17 | |
15 | |
13 |
User | Count |
---|---|
42 | |
36 | |
23 | |
22 | |
17 |