Hi, I want to create a dynamic table based on user parameter selection.

[Pra2010Gha]

In my backend table there are products and thier base price. the user will provide a parameter value (discount which varies for each product) and The calculated Selling Price is = base price * selected parameter value(discount).Now if i enter the parameter value it takes same value for all products but I want an out put where there are multiple products entered and different parameter values.Is that possible?

eg

Product  base Price 

TV        1000

fridge    250

now the out put I want is 

Product Base Price   Parameter Value (discount )  Selling Price

TV          1000               5% discount                      950(1000*.95)

fridge      250               2 % discount                      245 (250*.98)

[Rufyda]

Spoiler

Microsoft Learn References

RELATED function → https://learn.microsoft.com/en-us/dax/related-function-dax

Create relationships in Power BI → https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

[v-pgoloju]

Hi @Pra2010Gha,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @lbendlin and @Kedar_Pande  for prompt and helpful responses.

As mentioned by the @lbendlin  this functionality is not currently possible in standard Power BI. Parameters apply the same value across all rows, so assigning different parameter values per product isn’t supported yet.

Thanks & Regards,

Prasanna Kumar 

[Kedar_Pande]

Create a separate parameter table with products and their discount rates. Use that table in a many-to-one relationship with your products table.

Then create a calculated column:

Selling Price = 'Products'[Base Price] * (1 - 'Parameter Table'[Discount])

This allows different discount rates per product.

[Pra2010Gha]

can you please share a pbix file for this? so the parameter table  can take user input with different values for different  products?

[lbendlin]

Not yet possible in standard Power BI.  In Fabric they slowly move towards that with UDFs and Translytical Task Flows.

There may be (paid) third party visuals that support that.