I want to multiply all values of a column with a Measure which is derived from What if parameter.

[Velocity]

I have recently started working in PoweBI.

While Forecast_ROIFactor will remain constant in all rows, Forecast_ROI should be  Sale * Forecast_ROIFactor. My problem is that it is working only for the selected Week number - not for all weeks. It will be good to have a calculated column in my table.

I would like to share pbix file but don't know how to do it.

Any help will be greatly appreciated.

[Velocity]

Sharing PBIX file. Thanks.

https://1drv.ms/u/s!AlAhec3copzOiAiem9pqPtMVHRRV?e=541VPu

[amitchandak · Accepted solution]

@Velocity , Forecast_ReferenceROI is getting filtered. And you have used it everywhere. So everything got filtered. I have done some changes. You have check all calculations again. File is attached

[Velocity]

Thanks a ton Amit. I really appreciate your quick help.