cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CloudMonkey Member
Member

Can't link 2 columns, one of which is calculated

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?

 

Capture1.JPGCapture2.JPGCapture3.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Can't link 2 columns, one of which is calculated

@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.
4 REPLIES 4
CloudMonkey Member
Member

Re: Can't link 2 columns, one of which is calculated

This is the power bi file incase that's easier https://expirebox.com/download/ded42f08f5b1e1400a2fd0a92dcb3bd6.html

CloudMonkey Member
Member

Re: Can't link 2 columns, one of which is calculated

Did my question not make sense?

Community Support Team
Community Support Team

Re: Can't link 2 columns, one of which is calculated

@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.
Highlighted
CloudMonkey Member
Member

Re: Can't link 2 columns, one of which is calculated

Thank you @v-chuncz-msft Smiley Very Happy