How to create dynamic calculated column in PowerBI

[Anonymous]

Hi community, I need to show KPI of one single company compare with rest of the market in the dashboard, so want to add a dynamic calculated column( value be like "focus company" & "rest of market") into the raw table, and I need this column's value automatically changed based on user's choice of that single company. The user can choose the focus company they are interested in a slicer.  In tableau, it's easy to achieve this by using parameter. but I haven't found a solution in PowerBI yet. Does anyone did similar thing in powerBI before? Thank you!

[AntrikshSharma]

@Anonymous Calculated columns can't be dynamic, as no Filter Flows from Report View to the Data View.

[Anonymous]

I see, thank you!