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

[admin11]

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.

May i know where i go wrong ?

My PBI file :-

https://www.dropbox.com/s/dy93pmh38ixl4jq/PBT_V2021_393%20TI_SI_GL%20why%20AR%20table%20cannot%20fil...

Paul Yeo

[v-stephen-msft]

Hi @admin11 ,

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

Best Regards,

Stephen Tao

[admin11 · Accepted solution]

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