cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Add Column: conditional statement and numeric parameter

I created a numeric parameter that allows the user to choose a value between 0 and 20.

And a measure that tells me what number was chosen:

I have a table Product and I want to add a column that gives me the new price.

The column New Price should mantain the price for products B and C, and attribute a new price for product A that correspondes to the current price in table Product multiplied by the 'ChosenNumber'.
This is the result:

As you can see, for product A the new price is blank.

6 REPLIES 6
Super User

Hey @D_P Can you please share expected output?

Frequent Visitor

Assuming that this was the user input:

The expected output was:

Super User

Hey @D_P
Instead of creating a calculated column, create a measure using the below code

`New Price = IF(    SELECTEDVALUE(TableA[Name]) = "A",     CALCULATE(Parameter[Parameter Value] * SELECTEDVALUE(TableA[Price])),    MAX(TableA[Price]))`

You will get the following output

If this helps you then please give it a kudo and mark my solution as accepted so that other can find it quickly on facing similar issue. Thank You!

Frequent Visitor

Hi PowerBI wizard @Dhairya!
Thank you for the solution provided.
But on this specific case I really need it to be a calculated column.
Any other cards on your sleeve?

Super User

I don't think you can use a Measure in this type of Column calculation. If you swap out [ChosenNumber] for a literal value, it will show proper results, right?

 Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!

Frequent Visitor

Yes, you're right. But I need it to be dinamic, meaning, I need to be able to change it here

And see it reflected on the Product table.

Do you have any other suggestions on how this can be achieved?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors