How to build visual based on summarized table which can interact with filter from base table

Hi Leonzzheng,

Power bi does not support creating a dynamic calculated column/table based on filter/slicer. They are stored on different data levels and the parent level not respond with child-level operations.

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> virtual table of data view(measure, visual, filter, slicer)
Regards,

Xiaoxin Sheng