Forum Discussion
Slicer on Calculated Table
Hi. I have a calculated table 'average_per_product' formula is below. Table revenue has a relationship with table users. I want average_per_product table to be filtered by a slicer that uses users ta...
Hi Alex_Ra,
AFAIK, current power bi desktop does not support to create dynamic calculated column/tables based on filter effects. They not work on the same level and you can't use the child to effect its parent.
Notice: the data level of power bi(from parent to child level)
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng