Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello Everyone
I would like to achieve a rollup/hirerachy view for below table -
Hirerachy order should be -
1) Id
2) Solution
3) Example
I want to display its "Description" and "Subject No." for each "Solution" and "Example" .
The Problem is when I rollup to solution - I dont get the Description and Subject No. aside of it, as it is not present in underlying data.
Data -
Thank you.
Solved! Go to Solution.
Here's a full description of how to properly deal with parent-child hierarchies:
Here's a full description of how to properly deal with parent-child hierarchies:
User | Count |
---|---|
14 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |