How to obtain the max record for each one of the records

[rbustamante]

Hello,

I have the following table and I need DAX sentence to obtain the right table, that are the maximun values record of the left table.

Thanks in advance.

[Nathaniel_C]

Hi @rbustamante , 

Try this:

Max value = 
var _curId = MAX(SourceTable[ID]) //Get Current ID
var _curValue = MAX(SourceTable[Value]) //Get current value


var _calc = CALCULATE(MAX(SourceTable[Value]),FILTER(ALLEXCEPT(SourceTable,SourceTable[ID]), MAX(SourceTable[ID])=_curId))

Return 

IF(_curValue =  _calc,_calc)

If you leave off the value column, and just use the measure, you will get this.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[rbustamante]

Thanks for the response.

What do you mean whe you said "If you leave off the value column, and just use the measure, you will get this."?

[Nathaniel_C]

Hi @rbustamante ,
I created the table visual from the source table with 4 columns; Group, ID, Value, Max Value.  The Max Value is the measure that I created.  This shows all the values, and blanks in the measure column.

If you create the table with only Group, ID, and my measure Max Value you will see that the the reduced table with no blanks that more closely matches your table to the right of Desired Result.  It just depends on what you want to show.  A measure has a much smaller footprint than a calculated column.  It just depends on what you are using these values to do.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[lbendlin]

Please  provide more information. Should this be a calculated column or a measure?

Here is how a calculated column would look like:

Include = 
var m = CALCULATE(max('Table'[Value]),ALLEXCEPT('Table','Table'[Id]))
return if('Table'[Value]=m,1,0)