Excluding data from one table and adding from another

[Velvetine]

Hi all,

I have this sales table that have many outlets, which one of them is our online store. However, for online store this table isn't particularly accurate. So we have this another sales table which is only for online store. Is there a way for me to combine the table ?

Table A :

Date	Outlet	Sales
1/1/2022	ABC	100
1/1/2022	Online Store	250
1/1/2022	DEF	150

Table B :

Date	Outlet	Sales
1/1/2022	Online Store	150
1/1/2022	Online Store	200

I tried this : 

CALCULATE(SUM(Table A[Sales]), FILTER(Outlet<>"Online Store") + CALCULATE(SUM(Table B[Sales]))

I notice the formula above doesn't work when i try to visualize the sales based on outlet. For some reason the sales from Table B will add on to all the outlet instead of making it part of outlets

Appreciate your help on this matter.

Thanks !

[amitchandak · Accepted solution]

@Velvetine , You need to have common outlet and date table for that and join with both tabels and then try like

outlet = distinct(union(distinct(Table1[outlet ]),distinct(Table2[outlet ])))

CALCULATE(SUM(Table A[Sales]), FILTER(Outlet, Outlet[Outlet]<>"Online Store")) + CALCULATE(SUM(Table B[Sales]))