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 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

DAX
DirectQuery
Tips

2 Replies

  • 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 :