Forum Discussion
Error using SUMMARIZE() to filter out rows
- 1 year ago
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.
Thanks, however DAX gives the following error:
Resolve the error to see results
Query (19, 2) Each table argument of 'EXCEPT' must have the same number of columns.