Update Measure to all material number

[Muttagoss]

Am not able to update measure to all respective materials. In below example i want to update Price2 with $20 to all respective Materials. 

Sales Org	Sold To	Division	Material	Price1	Price2
XXX	123	11	Sugar	$20
XXX	456	22	Sugar
XXX	789	33	Sugar

[Muttagoss]

Thanks Amit. This solution is very helpful.

[amitchandak · Accepted solution]

@Muttagoss , Based on what I got

calculate(firstnonblankvalue([Material], max(Table[Price1])) , filter(allselected(Table), Table[Material] = max(Table[Material] ) ) )