max in condition

[#1]

hi

i have table like this:

OrderSpecificationDim_Key	TypeCheekDim_Key	adSanadId
1391002317	20	26886
1391002317	3	29402
1391002318	20	26888
1391002319	20	26890
1391002319	23	29611
1391002320	3	51628
1391002320	23	29609
1391002320	20	26892

i need too show TypeCheekDim_Key for any OrderSpecificationDim_Key forthe max value of adSanadId

for example when OrderSpecificationDim_Key=1391002320 i should show 3 because it has the biggest value of adSanadId. i have wrote :

if ( (Aggr(max([Ad Sanad Id]),[Id Order])=[Ad Sanad Id]),[Type Check Dim Key],0 )

but it is not true it seem. any one can help me?

[#2]

😞

[antoniotiman]

Try to remove Sum in Expression.

[Type check] instead of Sum([Type check])