Return back max value where ID's are the same

Question

Hi Experts&nbsp;I ONLY want to return back the MAX value where two ids are the same and the ID with the smallest value to be blank...Calculated column&nbsp;Mearure =VAR _maxvalue = calculate(MAX(Table[cost], Allexpect(Table,Table[SKID]))VAR _Result =&nbsp;IF(Table[Conseq] = 0,IF(_maxvaluue &gt; 1000000, "VB3",IF(_maxvaluue &gt;= 100000 &amp;&amp;&nbsp;(_maxvaluue &lt;= 1000000, "VB2B",IF(_maxvaluue &gt;= 25000 &amp;&amp;&nbsp;(_maxvaluue &lt;= 100000, "VB3B","VB1")))).&nbsp;the above measure is giving me max value for both ID'sIDCostCurrent RestultExpected Result12535421000100010001253542501000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Please try below dax formula:
Measure =
VAR cur_id =
    SELECTEDVALUE ( 'Table'[ID] )
VAR cur_cost =
    SELECTEDVALUE ( 'Table'[Cost] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[ID] = cur_id )
VAR max_cost =
    MAXX ( tmp, [Cost] )
VAR max_id =
    MAXX ( tmp, [ID] )
RETURN
    IF ( cur_id = max_id &amp;&amp; cur_cost = max_cost, max_cost, BLANK () )

Add a table visual with this measure and column:

Please refer the attached .pbix file.
&nbsp;
Best regards,Community Support Team_ Binbin YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Return back max value where ID's are the same

1 Reply

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2

Create Measure to Return Highest Value

ID	Cost	Current Restult	Expected Result
1253542	1000	1000	1000
1253542	50	1000