Forum Discussion
Helper IIMatrix filter only including child values
Helper IIHi Anonymous, thanks for following up. Unless I have missed something, based on what I've learned, it seems that what I'm trying to accomplish is not possible given how the underlying Power BI query is processing the matrix filters. The Performance Analyzer indicates that the parent/child hierarchy is being flattened via SUMMARIZECOLUMNS, which is not allowing my Measure filter to work as intended. If there is any way to work around this, or something that I have incorrectly interpreted, I would appreciate any further guidance.
Hi mollycat ,
Thanks for reaching out to the Microsoft fabric community forum.
One work around you could try is to create a new table called sortorder which contains numbers corresponding to child ID’s.
You could use that sortoder to now filter the matrix
Use is less than while filtering
Here is the output
Attaching .pbix file for reference.
I hope this information helps. Please do let us know if you have any further queries.
Thank you
- mollycat
Hi Anonymous, your example here doesn't quite meet my requirements as the issue is related to Parent records being removed from the matrix who don't have any children. Here, P1 and P2 both have Child records, so it does not address my issue. Thank you for the response!
Hi mollycat ,
In that case, as suggested by johnt75 and DataVitalizer , consider restructuring the data model for example, redesigning tables and reviewing relationships. A tweaked model may make it easier to achieve the desired output without relying on complex workarounds.
Thank youHi mollycat ,
Currently, if the provided suggestions are not working for your scenatio and If the required feature is important for your functionality, Please consider sharing your suggestion in the Power BI Ideas forum
Fabric Ideas - Microsoft Fabric Community
where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.
Thank you