cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Super User
Super User

My Bridge Table can trigger Sales Table customer ID But it cannot trigger for AR Table Customer ID ?

Hi All

 

I have already create a bridge table = Customer.

Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), all(SALES[CUST_ID])) )
 
With the above syntax , i am assume that i have link the AR Table and SALES Table Customer ID for both Table.
 
At Customer Table , i Create a Column for Flag Certain Customer ID = A10002 , using below syntax :-
_FLAG Customer Code = IF ( ( Customer[Customer/Vendor Code] IN { "A10002" } ), 1, 0)
 
I also assume that when i Click on _FLAG Customer Code = 1 , it should List from Both AR and SALES Table , when Customer ID = A10002
 
However to my surprise , it only able to filter from SALES Table , but it does not able to filter from AR Table.
 
admin11_0-1617248469508.png

 

May i know where i go wrong ?
 
My PBI file :-
 
 
Paul Yeo
 
1 ACCEPTED SOLUTION
admin11
Super User
Super User

Hi All

 

I just notice that i never link the AR Table and Customer Table . After i link them it work fine now.

 

Case closed.

 

Paul

 

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @admin11 ,

 

Please kindly Accept it as the solution. More people will benefit from it.

 

 

Best Regards,

Stephen Tao

admin11
Super User
Super User

Hi All

 

I just notice that i never link the AR Table and Customer Table . After i link them it work fine now.

 

Case closed.

 

Paul

 

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors