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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hey everyone,
I have a matix visual with a 3-stepped hierarchy. I want to display only values for the lowest hierarchy, so no aggregated data for level 1 and 2, but only 3. This is reached using the following measure, which works:
As I have locations in my 'table1' I have also a table 'location' with all detailed location information.
When I now try to filter by the locations in my table 'location' the data is filtered, but a "" is displayed, so all of the items are still there, without displaying any data. I have a unique ID for every location which is linked between the two tables.
When I use the location in my table 'table1' everything works out fine and only the items are shown which are filtered.
Do I miss anything or whats my mistake here?
Thanks for your help!
Lukas
@Anonymous , As of now min will come from row context
MIN('table1'[name])
so you need what you want , across all
calculate(MIN('table1'[name]), allselected(Table) )
or
calculate(MIN('table1'[name]), filter( allselected(Table), 'table1'[elementID] = max('table1'[elementID])
&& table1[subelement] = max(table1[subelement]) ) )
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.