Forum Discussion
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...
This the value that i enter manually in the field.
| Entered Manual value | Slicer changed it to this value. | Difference |
| 100,000 | 99901 | 99 |
| 150,000 | 149851 | 149 |
| 200,000 | 199801 | 199 |
| 250,000 | 249751 | 249 |
| 300,000 | 300200 | (200) |
| 350,000 | 350150 | (150) |
| 400,000 | 400100 | (100)
|
Slicer values changes.
See the difference for you to understand.
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.
HI sfaizee ,
Even i am also facing the same issue, can you please provide the resolution if it resolve from your end?
