Forum Discussion
Kebas_Leech
Helper I
3 years agoSummarize with ALL
Hello everyone,
I have the following function:
YEAR | MAX =
VAR vals =
SUMMARIZE(
'Date' ,
'Date'[Year],
"myMeasure", CALCULATE([Prod | Max | AllY], ALL('Date'))
)
VAR measureMax = MAXX(vals, [myMeasure])
VAR y_value = calculate(MAXX(FILTER(vals, [myMeasure] = measureMax), 'Date'[Year]))
RETURN
y_value
The measure [Prod | Max | AllY] is:
calculate(MAXX(BD,BD[Production]), ALL('Date'[Year]))
Both tables (BD and Date) are connected via Date[Date] -> BD[Date] in a 1-to-many relationship both directions.
I checked the var measureMax and its working properly.
The var y_value is however, wrong! Its returning the year as if the ALL function wasn't there.
I tried different approaches (like addcolumns and so on) but with no success.
What am I missing?
Thank you.
Solution was:
VAR MaxValue = calculate([Prod | Max | AllY], ALL('Date'[Year])) RETURN CALCULATE( MAX('Date'[Year]), FILTER( ALL('Date'[Year]), [Prod | Max | AllY] = MaxValue ) )
1 Reply
- Kebas_Leech
Helper I
Solution was:
VAR MaxValue = calculate([Prod | Max | AllY], ALL('Date'[Year])) RETURN CALCULATE( MAX('Date'[Year]), FILTER( ALL('Date'[Year]), [Prod | Max | AllY] = MaxValue ) )