How to replicate Parameters (tableau) in Power BI?

[Anushree1305]

This is the parameter created in Tableau and I want to create something similar in Power BI, as this parameter is then used to calculate a field called PLAN as below:

What is the best way I can achieve this in Power BI? I want to use this field "Plan" (sum) as my column value.

[Anushree1305 · Accepted solution]

I referred this youtube video and I created a reference table with the values I wanted and then wrote a measure to connect the main data to this reference table.
Here is the link for anyone who wants to do something similar:
https://www.youtube.com/watch?v=i6OvysJ_SIg

[lbendlin]

You can create the same type of parameter in Power Query.  If you want to use it in DAX you either need to convert it from an expression to a partition, or create a reference table instead.