I need to create a slicer in AAS model

Hi Anonymous,

Current power bi does not support creating a dynamic calculated column/table based on filter and slicer effect. (they are working on different levels, you cant use child level to affect its parent levels)
I'd like to suggest you create a measure instead then you can use it on the visual level filter to filter records.

Applying a measure filter in Power BI - SQLBI

Notice:

1. the data level of power bi.

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)

2. Create calculated column on database side also not be a good choice, these columns only update when the data source updates.

Regards,

Xiaoxin Sheng