How to use slicer filter for calculated table in power bi?

[Anonymous]

Hi, I need help how to pass slicer filter to my calculated tables.

I have a main table which I made a calculated table from using summarize and sum function. When I made a visual with reference to a column from the calculated table, it does not refresh when I use a slicer filter based on a column from my main table. 

[danextian]

Hi @Anonymous ,

A calcualted table update only upon creating the table or when the referenced table is refreshed. It does not respond to a slicer from another table and so is any other table if in data/table view. Slicers are applicable only in report view.  That being said, you must put the desired columns in a table visual and use the column from it or one from a related table to filter its view.

[Anonymous]

Thanks @danextian , are there really no workaround on this? I need the calculated column to summarize the data and input calculations.

[danextian]

Calculated tables don't work that way.  Anything physical (column or table) cannot be affected by slicers. Slicers affect visuals only. Your workaround is to create a calculated table that has all the possible rows and columns needed, add them to a visual and slice/filter them like they are in a non-calculated table.

Something like this will not work:

Calc table =
FILTER ( data, data[column] = [selectedvalue measure] )

While you can filter a calc table using a measure, the result is as if there is no filter at all so using the same example above if data[column] has more than one value, the result calc table will be empty as SELECTEDVALUE returns blank if there is more than one value which is the case if there are no filters at all.