Forum Discussion

mollycat's avatar
mollycat
Helper II
1 year ago

Matrix filter only including child values

Hello,   I have a Matrix which has a Measure that calculates a value at both the Parent and Child levels:   Record ID Title (calculated via Measure) Record A (Parent) Title A Record A ...
Need Help
v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi mollycat ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

 

Thanks and regards

mollycat's avatar
mollycat
Helper II
1 year ago

Hi @v-nmadadi-msft, 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. With this being case, there isn't a viable solution.