Forum Discussion

ItSupportElm's avatar
ItSupportElm
Icon for Helper III rankHelper III
5 years ago

If different value to same reference then false for all

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 re...
DAX
DirectQuery
Tips
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
ItSupportElm
Icon for Helper III rankHelper III
5 years ago

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 :