cancel
Showing results for
Did you mean:
Highlighted
Resolver I

## Relationship change the result of a formula

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

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver I

## Re: Relationship change the result of a formula

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

Resolver I

## Re: Relationship change the result of a formula

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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors