how to create a measure using the parameter

[Anonymous]

Hi experts.

I need advise in one measure.

I have created three coditional columns using 9 parameters as shown in the image. names are= exported-stage, sent to next stage, and sold to customer.Now I wanted to create a fourth calculated column using the 10th parameter named volume whose value is 10000 by defualt. as you can see in the screenshot.

now I want to calculate the same thing which  I previously discussed that is , i

if stage =harvest  then volume = 10000 (parameter value)

if stage = primary processing  then volume = 10% *10000(paramter value)

if stage=further processing = then volume = 40%* (10% of 10000) which is 1000.

exactly the same you solved previously.

I would really appreciate your thoughts on it.

[lbendlin]

This is all still in Power Query, no measures involved. 

Can you provide a sample pbix, or the contents of Section1 in your .m file?

[Anonymous]

Thanks @lbendlin ,

I'm working on it. 
Could you please tell me what could be the syntax of if condition in M langugage. 

I want to setup a condition that sum of three parameter could not exceed the 100%.

waiting for your prompt reply.

[lbendlin]

There is no special syntax in M.  Lots of nested ifs.

if [stage] = "harvest"  then 10000

else if [stage] = "primary processing"  then 0.1*10000

else if [stage] = "further processing" then 0.4*0.1*10000

[Anonymous]

I got it this part, thanx for the reply,

However, I am looking something where I can set up a condition 

if export+next stgae+sold to consumers >1 then show error msg "values exceed" otherwise enter user values.

[v-chenwuz-msft]

Hi @Anonymous ,

Please use #"parameter name" to invoke parameters in your power query editor.

Best Regards

Community Support Team _ chenwu zhu

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

[Anonymous]

Hi @v-chenwuz-msft , 

I dont want to create a coulmn, I already created a column using parameters. 
I have 3 coulmn names export, next stage and sold to consumers.

Just want to say for example in export column I have a parameter A, and In next stage I have B, and In sold to consumer I have parameter C,

I want some condition like that sum of these 3 parameters which are in 3 different column should not exceed 1.

if (A+B+c =1, then parameters value should display in the coulmn other wise error msg.

I hope it will help 

[lbendlin]

"Parameter" has a different meaning in Power BI. It is still not clear what you are trying to achieve.

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

Hi @lbendlin  and @v-chenwuz-msft ,

I have a question, I have created a report in which I entered the data manually inside the power bi desktop and create some parameters and publish it to power bi service.

the problem is whenever I changed the value of paramters in Power Bi service (In side setting pane)  its not reflecting in the power BI report which I published. 

I refreshed the datasets but its keep refreshing and doesn't  updating the values.

it show me this error :

Please guide me in this regards

[lbendlin]

Intriguing question.  Will need to do some research on this.  is this an air-gapped scenario of some sort?  What's the deep reason behind pasting the data in manually?  What is the expected user experience?  Why are parameters needed at all?