Slicer on Calculated Table

[Alex_Ra]

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 table - how could I achieve it?

average_per_product = 
    groupby(
        addcolumns(
            groupby(
                revenue, 
                revenue[client_id], 
                revenue[billing_cycle],
                revenue[first_product_name]),
            "avg_per_user", calculate(sum(revenue[gross_tax]))
        ), 
        revenue[billing_cycle],
        revenue[first_product_name],
    "avg_per_product", averagex(currentgroup(), [avg_per_user]))

[Anonymous]

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