If different value to same reference then false for all

[ItSupportElm]

Hello everyone,

Hope you good, i need your help please about an issue :

I have the same "IdRetour" for different reference, and i want if one of "PriseEnGarantie" is False all the reference return False, the three IdRetour "107" is false.

Thank for the futur answer, and sorry if my english is not that good.

Good Day

[amitchandak]

@ItSupportElm , Create a new column as

new column =
var _cnt = countx(filter(Table, [IdRetour] = earlier([IdRetour]) && [PriseEnGarantie]=false()),[PriseEnGarantie])+0
return
if(_cnt >0, false(), true())

[ItSupportElm]

Thank you for ansering o quickly @amitchandak  , i try your formula but it didnt work im in direct query i dont know if it change anything.

here the error :