Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jasemilly
Helper II
Helper II

What if parameters on calculated Column

Hi 

I have some a source table that is used for some margin comparisons pulling from an SQL source, it contains a hardcoded percentage increase and a minimum cost value that work fine.

 

The users would like to be able to change the minimum cost value and the percentage increase value for different customers. 

 

I have been looking at the "what if" scenrio and parameters

 

The minimum cost value that has to be applied to each row before aggregating.  I am trying to use a calculated column and parameters but I don't believe this will work, I havent had any success the moment.   


If I can't pass parameters into a calculated column could I use power apps to pass back to the source SQL view and then refresh the power bi report?

If I had the percantage at 10% and the minimum cost at £35, the underlying table would look like this.

id   cost       margin increase   new price

1    30         33                         35

2    40         44                         44

3   20         22                          35

 

thanks for all help.

1 ACCEPTED SOLUTION

I have decided to create a lookup table that holds values and create a view in SQL to handle.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @jasemilly ,

 

What if parameter can be only used in measures not in columns.

Could you consider using measure to achieve this?

 

Best Regards,

Jay

I have decided to create a lookup table that holds values and create a view in SQL to handle.

Greg_Deckler
Community Champion
Community Champion

@jasemilly You definitely can't use measures to dynamically change column values. Column values are only calculated at the time of data load/refresh. You would use a What If parameter which creates a disconnected table that you would then use in a Measure to perform some calculation, but I am not clear on the calculation you wish to perform.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

I would like the user to be able specify a minimum value using the whatif then checking the value of each row in the underlying table.

if  new cost is less than the minimum it becomes the new value.

 

two parameters 

new minimum cost is      20

percentage increase       10%

 

underlying table

orignal cost    new cost after percentage increse   new cost isn't greater than minimum, so becomes minimum

10                   11                                                     20

                                                                                new cost is greayer than minimum so is ok as is

30                   33                                                    33

amitchandak
Super User
Super User

@jasemilly , have tried what if parameter : https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.