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 ...
Anonymous
4 years agoNot applicable
Thanks jaap_olsthoorn - I think that using SUMMARIZE would be recommended over the use of VALUES and CALCULATE. The suggestion to use Two measures was a little odd. amitchandak suggestion was much better.
This is what I would have used:
test recovery =
SUMX (
SUMMARIZE (
'Test Table',
'Test Table'[MLP],
"Max", MAX ( 'Test Table'[Recovery] )
),
[Max]
)
Maybe this will be a good video for AlbertoFerrari to highlight when to use VALUES versus SUMMARIZE.