Value from A to B, one to many relationship, related tables

[Anonymous]

Hi all,

I have the following structure:

Table A

accountID  Days Since Rank

id1                -42            1

id1                -45            2

id1                -47            3

id2                -5              1

id2                -15            2

id3                -19            3

....

Table B

accountID

id1

id2

...

I would like to get into Table B Days Since value where rank is equal to 1 for every account so the table B looks sth like this:

Table B

accountId    Days Since

id1                     -42

id2                      -5

Tried using Calculate(FIRSTNONBLANK(Table A [Days Since],0), Filter(Table A, Table A[Rank] =1)) but I get same values for all accounts.

Thanks for your help!

[Anonymous · Accepted solution]

double Calculate ( Calculate (... solved the problem. putting a context to filter.

[Anonymous]

Sorted.

[Anonymous]

Great you found the solution. Appriciate if you can post the solution as well, so that if this post is searched somewhere then this can help others.

Thanks.