DAX or Custom Column

[DemandMGR]

I have a large dataset that includes DC#, UPC#, & Sale#.

I am trying to identify what the maxsale price is by UPC. I would like a column or a measure that would add to a table that will show the largest sale price for the UPC on every row. All data is in the same table. I have over a million rows here. 

I dont really know what to put in the first half of the statement to have it locate the UPC.

I think the second part of the statement would be CALCULATE(MAX('TABLE[SALE$] but for the first part would it be VALUES('TABLE[UPC] or maybe FILTER('TABLE[UPC]?

I tried MAXX('TABLE[UPC] , CALCULATE(MAX('TABLE[SALES$] and that just gave me the sales price on the row but it didnt give me the Max Sales$ value by UPC.

Any help would be greatly appreciated. Thank you in advance. I should add that there are repeat UPCs in each DC and each DC has a differet sale price for the UPC

[Anonymous]

Hi @DemandMGR 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523