Forum Discussion
MAX MIN, AVERAGE
I have the following measures. Weekly Demand is calculated correctly. But now I want to calculate Max, Min and Average Weekly Demand. Expected output : The measure should pick the Max value,...
Anonymous OK, so let's say you want a single MAX of your MinScoreMeasure, that would be this:
Max Min Score = VAR __Table = SUMMARIZE( 'Table', [VT Code], [Customer Material Code], [WeekNo], "__Min", [MinScoreMeasure] ) VAR __Result = MAXX( __Table, [__Min] ) RETURN __Result
Greg_Deckler
I want only one MIN value from the weekly demand measure.
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
This measure gives me Min value week-wise.
Greg_Deckler
Community Champion
Community ChampionAnonymous OK, so let's say you want a single MAX of your MinScoreMeasure, that would be this:
Max Min Score =
VAR __Table =
SUMMARIZE(
'Table',
[VT Code],
[Customer Material Code],
[WeekNo],
"__Min", [MinScoreMeasure]
)
VAR __Result = MAXX( __Table, [__Min] )
RETURN
__Result