Relationship change the result of a formula

[FRG]

Hi everybody,

I have 2 tables with a relationship with the 2 IDRun columns

1. Scalings:

 

2. And ProdRun

I made a calculated column to merge IDRun and RunSpecies in the 2 tables: ColonneCombine.

I made another calculated column comparing IDRun and ColonneCombine of both tables with this formula:

if(and(Scalings[IDRun] = RELATED(Prodrun[idRun]);Scalings[ColonneCombine] = RELATED(Prodrun[ColonneCombine2]));1;0)

With this column I want to create a new one who gives me the «reel IDRun». All these steps works well.

Now I want to change the relationship for the new «reel IDRun» column but once its done, the formula up here return 0 for each rows.

With no change in the relationship, everything is OK.

Where is my error.

Thanks

[FRG · Accepted solution]

I got a solution. I change my formula to compare the 2 IDRun:

CompareSpecies = if(Scalings[SupposeIDRun] = LOOKUPVALUE('13021sorter prodrun'[idRun];'13021sorter prodrun'[ColonneCombine2];Scalings[ColonneCombine]);1;0)

Thanks