How to sum value from 2 table without relation ?

[sakuragihana]

Hello everyone, I have 2 table below : 

Table 1 : 

Table 2 : 

I post a plib in that link :https://drive.google.com/file/d/1i_KvhMvTM1HVo95eszcauvlLFLG2FRj2/view?usp=sharing 

How can I add the provinces in table 2 (Campus Code is Unspecified) respectively to table 1 (as same as Province Name) ? Can everyone help me a dax ?

Table 1 like : 

[CNENFRNL]

Simple enough, use TREATAS() to create virtual relationship on the fly if the perfomance is not a big concern.

[sakuragihana]

Hi @CNENFRNL , 

Can you help me ?

[CNENFRNL]

Paste well-prepared mock-up data first.

[sakuragihana]

Hi @CNENFRNL , 

I fix this pibx link: https://drive.google.com/file/d/1v5l0TgW5xPf0o5IqxBqPHSJ59jM-fP-8/view?usp=share_link 

Sorry for inconvenience. Thank you 

[CNENFRNL]

[sakuragihana]

Hi @CNENFRNL , 

I want to Sum value from table 2 into table 1 and don't show the row Unspecified . 

Example :

[sakuragihana]

Hi @CNENFRNL , 

I don't know how to use TREATAS , can you see the pibx I attached and help me 

[amitchandak]

@sakuragihana , You need to create common dimensions like Province Name, date tec

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

[sakuragihana]

Hi @amitchandak ,

I want to sum value from Table 2 that Campus Code is unspecified into Table 1 (respectively Province Name ) . I don't want to show Unspecified in the table 1

Table 1 like as : 

Can you help me a dax ?