Forum Discussion
Error using SUMMARIZE() to filter out rows
Hi quijote,
Thank you for the update. We appreciate the effort you’ve put into exploring different solutions and developing your own approach. We understand that unique scenarios like the "GLOBAL + Country" case often require customized logic, especially with complex filtering needs. While our suggestions may not have fully addressed your requirements, we are pleased to see you are testing your own workaround.
In parallel, we’ll revisit this scenario on our end to see if we can provide a more precise solution that meets your need to filter out redundant country rows when "GLOBAL" is present for an issue.
If your custom approach works well, we’d appreciate it if you could share it with the community, as it may help others with similar data challenges.
Thank you.
Community SupportHi quijote,
I wanted to check in your situation regarding the issue. Have you resolved it? Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Thanks for reaching out. None of the solutions provided fulfilled my exact requirements, but I did manage to devise my own solution, which is under test right now. Therefore, I cannot accept any of the replies as the official solution on this occasion.
- v-sgandrathi
Hi quijote,
Thank you for the update. We appreciate the effort you’ve put into exploring different solutions and developing your own approach. We understand that unique scenarios like the "GLOBAL + Country" case often require customized logic, especially with complex filtering needs. While our suggestions may not have fully addressed your requirements, we are pleased to see you are testing your own workaround.
In parallel, we’ll revisit this scenario on our end to see if we can provide a more precise solution that meets your need to filter out redundant country rows when "GLOBAL" is present for an issue.
If your custom approach works well, we’d appreciate it if you could share it with the community, as it may help others with similar data challenges.
Thank you.