Forum Discussion
Return back max value where ID's are the same
Hi Experts 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 Mearure = VAR _maxvalue = calculate(MAX(Ta...
Hi Anonymous ,
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 && cur_cost = max_cost, max_cost, BLANK () )Add a table visual with this measure and column:
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
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 && cur_cost = max_cost, max_cost, BLANK () )
Add a table visual with this measure and column:
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.