Need assistance on data slicer

[Krishna1992]

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.

[v-juanli-msft]

Hi @Krishna1992

calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report, you need to create a measure so it can change with the slicer.

Could you show some data in table visual so i can analyze better?

Best Regards

Maggie

[Krishna1992 · Accepted solution]

Hi @v-juanli-msft,

I accept your statement.

But calculate tables works during slicer also. 

The issue here is I haven't made proper relationship between tables.

Previously relationship between derived tables and other data table is dotted line.

I enabled "Make relationship actice" which converts the relation from dotted line to normal line, and when I selected a value in slicer it works.

So more or less this is a modelling issue which I faced.