Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Roll-up the data


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 - 

Rid123_0-1631486433039.png


Thank you.

1 ACCEPTED SOLUTION
daxer-almighty
Solution Sage
Solution Sage

Here's a full description of how to properly deal with parent-child hierarchies:

Parent-child hierarchies – DAX Patterns

View solution in original post

1 REPLY 1
daxer-almighty
Solution Sage
Solution Sage

Here's a full description of how to properly deal with parent-child hierarchies:

Parent-child hierarchies – DAX Patterns

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.