Forum Discussion

sfaizee's avatar
sfaizee
Helper I
5 years ago

What if parameter value keeps changing single value

HI Everyone, I have created a what-if parameter in my report that takes in a single value (Slicer).  When i open the paramter. It has the below code. (the checked marker) length = GENERATESERI...
Need Help
sfaizee's avatar
sfaizee
Helper I
5 years ago

Just to clarify the point a bit more. 

I used a whatif parameter with Data type as whole number

and DONT SUMMARIZE.

This created a parameter:

length = GENERATESERIES(1, 500000)

and a measure

Parameter Value = SELECTEDVALUE('length'[Parameter], 100)
 
Now when i enter the value in the slicer manually. 
The values change
Such changes effect the further measures that i have in my report. I am calculating the rates based on length and time. 
Similarly 3 more what if's in this report. 
Setup Time = GENERATESERIES(1, 20000, 1)
Measure 
Setup Time Value = SELECTEDVALUE('Setup Time'[Setup Time])
Here are the results of manual entry. 
 
Thanks for your help. 
Regards,
Sahim. 
 
 
 
 
 

 

 

 

sfaizee's avatar
sfaizee
Helper I
5 years ago

amitchandak 

I have added the detail result. 

Could you please check and advise me

Thanks.

 

  • prakash11440278's avatar
    prakash11440278
    Post Prodigy
    5 years ago

    HI sfaizee ,

     

    Even i am also facing the same issue, can you please provide the resolution if it resolve from your end?