Forum Discussion

MPICKETT's avatar
MPICKETT
Frequent Visitor
7 years ago
Solved

Identify Duplicate with the Highest Value

Hello All - I am attempting to use a calculated column to identify the duplicate rows with the highest value. I know how to do this in Excel, using the COUNTIFS function, however, I have been strugg...
  • BekahLoSurdo's avatar
    BekahLoSurdo
    7 years ago

    Hi MPICKETT,

     

    Would this work?

     

    Driver Choice = IF ( 
	CALCULATE ( 
		MAX ( 'Driver Relationship Table'[Stops per Week] ), 
		ALLEXCEPT ( 'Driver Relationship Table', 'Driver Relationship Table'[Year.Wk], 'Driver Relationship Table'[DriverName] )
	) = 'Driver Relationship Table'[Stops per Week], 
	1, 
	0
)

    Best,

    Bekah

BekahLoSurdo's avatar
BekahLoSurdo
Resolver IV
7 years ago

Hi MPICKETT,

 

Would this work?

 

Driver Choice = IF ( 
	CALCULATE ( 
		MAX ( 'Driver Relationship Table'[Stops per Week] ), 
		ALLEXCEPT ( 'Driver Relationship Table', 'Driver Relationship Table'[Year.Wk], 'Driver Relationship Table'[DriverName] )
	) = 'Driver Relationship Table'[Stops per Week], 
	1, 
	0
)

Best,

Bekah

  • MPICKETT's avatar
    MPICKETT
    Frequent Visitor
    7 years ago

    I knew I was overcomplicating things. That did the trick!

    Thank you so much Bekah!