Forum Discussion

Alex_Ra's avatar
Alex_Ra
Frequent Visitor
3 years ago

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 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]))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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