Help with Dax mesaures to calculate values in a table ( max value and related values)

Romulo1973 — Wed, 14 Jun 2023 15:02:29 GMT

Hi everybody.

Could you be so kind to help me with this DAX measures:

I tryed to calculate a DAX Formula to get de MAX Value of a column and get other values of the same of table(summarized table, show below called Resumen) is ordered by No Order ( shown in red box) , and I need to calculate de max of the value of ( Ton Desc Mat, shown by blue box) and then get the material ( shown by Orange box) and STD ( shown by green box) values.

In the next example, there is a Order 3472( red box), it has 2 rows ( 2 diferents materials), and then i need calculate the max ton desc mat; in this case is 4,802.56 ( blue box) , and get the values of STD ( 7,500 in green box) and Material ( Bauxita in Orange box) in diferents columns.

Thanks in advance for your help.

Regards

Re: Help with Dax mesaures to calculate values in a table ( max value and related values)

lbendlin — Sun, 18 Jun 2023 18:05:00 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

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

topic Re: Help with Dax mesaures to calculate values in a table ( max value and related values) in DAX Commands and Tips

Help with Dax mesaures to calculate values in a table ( max value and related values)

Re: Help with Dax mesaures to calculate values in a table ( max value and related values)