Measure based on maximum of previous measure

[MrMP]

Hi all,

I have the following structure:

Product	Price	Measure1	Measure2
AA	190	1200	192
AA	192	1300	192
AA	193	500	192
AA	192	200	192
BB	92	300	92
BB	94	150	92

I need to create a measure that finds the maximum of Measure1 and then write the right price for it in Measure2 based on Product.

Thank you!

[CNENFRNL]

Use TOPN to retrieve the price corresponding to the max Measure1. The pattern is as follows,

Measure2 =
MAXX( TOPN( 1, ALL( tbl[Price] ), [Measure1] ), tbl[Price] )

[Jihwan_Kim · Accepted solution]

Hi, @MrMP 

I am not sure if I understood your question correctly, but please check the below.

Measure1 measure =

SUM('Sales'[Measure1])

Measure1 MAX =

MAXX ( ALLEXCEPT ( Sales, Sales[Product] ), [Measure1 measure] )

Price of measure1 max =

CALCULATE (

SUM ( Sales[Price] ),

FILTER (

ALLEXCEPT ( Sales, Sales[Product] ),

[Measure1 measure] = [Measure1 MAX]

)

)

https://www.dropbox.com/s/dm8zir5ckb8deif/mrmpv3.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM