jaap_olsthoorn
Advocate II
4 years agoStatus:
Investigating
SUMX producing wrong result when filtered in both row context and filter context
Hi all! Sorry for the title, I just have no good way of explaining this issue. Example file: https://drive.google.com/file/d/1lc-GdEEYAMYjqrm1YfVm9wuWE9Ls_gRq/view?usp=sharing I have a table ...
jaap_olsthoorn
Advocate II
4 years agoYea like I said, his solution works. I'm just super curious why the values or distinct version does not, because in most cases (where you dont have the owner in a filter AND in a visual) it works just fine! As far as I can tell, there is no good reason for SUMX to fail here...
Edit: Alberto gets it. It's not the solution I'm looking for, it's the explanation / bugfix 🙂