Need assistance on data slicer

Hello Everyone,

I have 4 data tables, 1 time intelligence table(calendar) where this table is connected to every other data tables.

I performed a calculated column called overall revenue based on all 4 tables. Used below DAX expression to calculate overall revenue.

SUM(DespatchReport[Amount])+SUM(ExportBillingReport[Amount])+SUM(FCL[TOTAL BILLING])+SUM(LCL[Total Revenue Generated])

After that I created a new table to create a slicer, and that new table is also connected to every other tables.

Below is expression I have used to create a new table,

WTYPE = FILTER(DISTINCT(UNION(SELECTCOLUMNS(DespatchReport,"Warehouse_type",[Warehouse_type]),
SELECTCOLUMNS(ExportBillingReport,"Warehouse_type",[Warehouse_type]),
SELECTCOLUMNS(FCL,"Warehouse_type",[Warehouse_type]),
SELECTCOLUMNS(LCL,"Warehouse_type",[Warehouse_type]))),NOT ISBLANK([Warehouse_type]))

My problem is I created the slicer based on new table created, I want to slice Eg. If I click on value 1 only that revenue should be filtered, but it is not doing so.

since I created a calculated column in LCL table, that value only shows.  Other tables I cannot able to filter or visualize it.

Slicer values:

FCL

LCL

Bond

Export

Needed Output:

FCL is sliced FCL revenue need to be filtered and other slicers too.

Error:

When I select LCL slicer, overall revenue gets outputted. (because I created a calculated column in that table only).

How can I overcome and slice each and every table. Is this modelling issue or any other issue? Please help me out.

Thanks.