Solved: Re: Can't link 2 columns, one of which is calculat...

CloudMonkey · ‎02-01-2018

Hello 🙂

I am trying to link column "Branch" in table 1 with column "Highest branch number for brand" in table 2. But the link does not work. I suspect the problem is that "Highest branch number for brand" is a calculated field that refers to table 1 but please could someone tell me why that means I can't create a link? How should I go about this?

v-chuncz-msft · ‎02-02-2018

@CloudMonkey,

You may change it as follows.

Highest branch number for brand =
MAXX (
    FILTER ( 'table 1', 'table 1'[Brand] = 'table 2'[Brand ] ),
    'table 1'[Branch]
)

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎02-02-2018

@CloudMonkey,

You may change it as follows.

Highest branch number for brand =
MAXX (
    FILTER ( 'table 1', 'table 1'[Brand] = 'table 2'[Brand ] ),
    'table 1'[Branch]
)

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.