Forum Discussion
Solved
Power BI DAX Filter Matrix/Table Based on Slicer Hierarchy Level
I've a parent / child slicer and would like to apply an extra filter when a child value is selected. I want to use the native slicer and build a hierachy with Business as parent and Product as child...
vidhyasankar
My suggest is just include the filter column in the Hierarchy. Otherwise you may need to create a distinct table with a few measures making measures to filter to the selected slicer.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
samdthompson
Memorable Member
Memorable MemberHello, heres a really good explanation of creating the heirarchy you need:
https://www.daxpatterns.com/parent-child-hierarchies/
Thanks a lot for the response! The link shows calculation of measures based on parent / child hierarchy. In my requirement there are no numerical values. Just apply extra filter to exclude cetrain rows if a child member is selected.