Calculate a column with a percentage range

[Anonymous]

Hello guys,

can anyone help me with this issue? 
I am trying to calculate a column of numbers, let's called it ordervalue, with a percentage range of 4-7%.

Example: 

120000 * 4-7% = 

How can I do that ? 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can try what-if parameters to get the dynamic percentage range.

Use parameters to visualize variables - Power BI | Microsoft Learn

1.Create what-if parameters.

Create a measure to calculate. Because it is a dynamic result, only measures can be used here, and the calculated column is a static result.

You can slide the slicer to get different values to multiply the Order Value.

Measure = SUM('Table'[Order Value])*[Parameter Value]

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[TomMartens]

Hey @Anonymous ,

I have to admit that I do not understand the expected outcome.

Basically, it's not possible to store multiple numeric values in a single cell within Power BI. Either you create multiple rows, or multiple column. My recommendation is multiple rows.

I consider the information you provided scarce, for this reaeson, I'm not able to provide more guidance or even a solution.

Regards,

Tom

[Anonymous]

First thank you for you fast reply,

To make things clear: I didn't mean a single cell. It was just a quick example of the calculation I am trying to do...so sorry for that 😄 

I am trying to calculate the numbers of a column, called ordervale, with a percantage range 

Column
Order Value
891283

1784

7848

38912

7898

500

38912

600

Now I need a new column or measure, that helps me calculate all of these numbers with the range of 4-7%.