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!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have table with information about machine parts.
Initial Data looks like:
| Level 1 | Level 2 | Name |
| A | - | aaa |
| A | A1 | bbb |
| A | A2 | ccc |
I want to sea a hierarchy of Level 1 and Level2, so I need to drag Lebel1 and Level2 to Rows.
Example of expected data in matrix:
| Level 1 | Name |
| A | aaa |
↓ Drill
| Level 1 | Level 2 | Name |
| A | - | aaa |
| A1 | bbb | |
| A2 | ccc |
But the matrix displayed like this:
| Level 1 | Name |
| A | bbb |
↓ Drill
| Level 1 | Level 2 | Name |
| A | - | aaa |
| A1 | bbb | |
| A2 | ccc |
I want to display "aaa" as name of "A".
Please tell me if there is any solution to that.
@Ryo15 , use is in scope
Switch( True() ,
isinscope(Table[Level 2]), Max(Table[Name])
calculate( Max(Table[Name]) , filter(Table, Table[Level 2] = "-"))
)
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 52 | |
| 51 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 92 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |