https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2095145#M47750 <DIV><DIV><DIV><DIV><DIV><DIV><DIV>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" &amp;&nbsp;"rest of market") into the&nbsp;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.&nbsp; 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!</DIV></DIV></DIV></DIV></DIV></DIV></DIV> Thu, 23 Sep 2021 17:19:43 GMT Anonymous 2021-09-23T17:19:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2095145#M47750 <DIV><DIV><DIV><DIV><DIV><DIV><DIV>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" &amp;&nbsp;"rest of market") into the&nbsp;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.&nbsp; 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!</DIV></DIV></DIV></DIV></DIV></DIV></DIV> Thu, 23 Sep 2021 17:19:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2095145#M47750 Anonymous 2021-09-23T17:19:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2095233#M47754 <P>Anonymous</LI-USER>&nbsp;Calculated columns can't be dynamic, as no Filter Flows from Report View to the Data View.</P> Thu, 23 Sep 2021 18:54:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2095233#M47754 AntrikshSharma 2021-09-23T18:54:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2101188#M47955 <P>I see, thank you!</P> Mon, 27 Sep 2021 20:29:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-dynamic-calculated-column-in-PowerBI/m-p/2101188#M47955 Anonymous 2021-09-27T20:29:51Z