Possible to recalculate a measure to another measure again?

[selected_]

If I have a measure already that name Selling Price, the measure selling price look like this

AVERAGE('Products'[UnitPrice]) * ([Total Discount])

can I then create a new measure and calculate MAX and MIN for the measure?

I tried with this  MAX of Selling price = CALCULATE(MAX([Selling Price])) 

but got error.

[v-kelly-msft · Accepted solution]

Hi @selected_ ，

Yes,you can create 2 measures similarly as below:

Min sales price = MinX(VALUES('Table'[UnitPrice]),'Table'[Selling Price])

Max sales price = MAXX(VALUES('Table'[UnitPrice]),'Table'[Selling Price])

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

@selected_ This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.