Building/calculate column values in a table based on numeric value in the measure

[Anonymous]

I am looking at developing a dynamic table(Table 1) whose columns are A and B. A contains text X1, X2,....X6. B contains numbers to be calculated based on numberic value of measure Z, which is depended on the user selection of filters.

if z= 200 --- value of this measure is dependent on the user selection of filters in the power BI
Table 1

A      B     formula for column B

X1   20    (0.1*z)
X2   30    (0.15*z)
X3   50    (0.25*z)
...

X6 

If Z = 300, the values in column B should auto calculate using above formula for column B

Kindly help!

[v-juanli-msft]

Hi @Anonymous 

You could create a what-if parameter and then use it in a measure.

Measure_B = SUM('Table'[Rate])*[Parameter Value]

But it is a measure instead of a column.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Try what-if parameter

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

https://www.absentdata.com/power-bi/parameter-power-bi/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601