Student question: how to display only child values in a parent-child hierarchy, ignoring aggregations? Watch the solution implemented step-by-step! Read more about the "unplugged" format: www.sqlbi.com/... #unplugged
Thanks. The solution is great for for the data i'm working with. I am using a Hierarchy Filter (with RLS) to control the PBI matrix visual. Can I only display the current and child nodes in the matrix visual such that values across all levels are consistent? Thanks! Base Matrix Root | 90 A | 100 A.1 | 30 A.2 | 10 B | 70 B.1 | 30 B.1.2 | 12 Select B.1 on Hierachy Required: B.1 | 30 B.1.2 | 12 Current result: Root | 30 B | 30 B.1 | 30 B.1.2 | 12
Today I tried to do something similar to this but I had no idea. I wanted to show only parent value and hide child level. I think it will be a modification of this case. Thanks :)
Great video as always. But seems that DAX could only handle balanced hierarchy, which means one child always belong to one parent like Year-Quater-Month. I am wondering if unbalanced hierarchy like BOM could handled in power bi. for example, Component A (1 PC) is composed of B (2PC) , C(3PC), D(4PC), while B (1PC) again is composed of C(2PC) and E(1PC), then C (1PC) again is composed of D(3PC) and F(1PC) , and all these information is stored in a single table with 3 column, parent, component, qty. Then how could this hierarchy information be shown in power bi with Dax, and how to extend the BOM of component A to only include the lowest level with the quantity D (25 PC), E(2 PC) and F(7 PC).
You can find several examples here: www.daxpatterns.com/parent-child-hierarchies/ The real issue for BOM is that you don't have a real good native solution for the multi-level organization - a pre-processing that allocates B native components into A components is required. It's possible, but relatively complex and not really managed by DAX because there is no recursion available in this language.
@@SQLBI Thanks for your clarification. Then the best way is still to use SQL common table expression to do recursive join to extend the BOM. hope one day DAX could handle Recursion.
@@SQLBI Thank you very much for the detailed answer! That's exactly what I meant in my question. I myself want to use it to check the BOM in more detail. If you have any analytical thoughts on this topic, I would love to read them. Thank you for your excellent work over the years!
In your video, you're displaying the problem I'm trying to solve - when I see the children indented below the parent, I have a blank label for the data applying to the parent. How do I get the parent label to populate in the child level when the parent has data?
Hi Alberto, Is it possible to show always child value ? What I mean is that if we add in your file slicer with hierarchy (Dim[Lev1],Dim[Lev2],Dim[Lev3]) and than select "F" from Dim[Lev3], we will see "No Agg" at all level - 25, but the desire result would be A - 110, B - 40, F - 25
Hi Alberto, Good evening. A co-worker left the company and now I need to edit an APP that he is the owner of. I have to revise a few measures but I am not able to edit them. Options to download, etc are greyed out. Is there any solution to this case? Is there any application that I can use ? Thanks