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 agoHi there, thanks for the response.
I did already know how it's supposed to work. In my case, SUMX should do exactly what I need (SUM aggregate the recovery on a MAX basis, iterating over the MLP column). Unfortunately, it stops working when applying the filters as described in my example. Did you test the example file?