What if parameter value keeps changing single value

[sfaizee]

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 = GENERATESERIES(1, 500000)

My requirement is to be able to enter an whole number (selected) with an exact length (any number between 1 and 500,000). 

The next DAX measure is 

Parameter Value = SELECTEDVALUE('length'[Parameter], 100)

Now, when i enter the value as 300,000; the system changes it to 300,200? Why is it adding 200 i dont understand. 

Can you please help me. 

Thanks.

[jstew0809]

It is 2024 and this issue is still not fixed. What a joke.

[KiwiFox]

May 2023, still same problem.

I love how we have to pay for a product that has bugs and then gather enough votes to fix said bugs.. Lovely

[titaregina]

Seems like this issue has not been resolved. Anyone still having the same issue?

[sfaizee]

I could not find the solution to this problem. 

Any help?!

[sfaizee]

Does anyone else face the same problem. 

Any help would be greatly appreaciated. 

Thanks.

[amitchandak]

@sfaizee , Are you entering the value manually or using slicer. Sometimes with slicer excat value might get selected .

I used what with excat values.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[sfaizee]

Hi, 

I am entering the data manually. 

The slicer has a scroll bar as well that i have kept open. 

Even turning it off didnt help. 

[sfaizee]

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. 

[sfaizee]

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]

@amitchandak 

I have added the detail result. 

Could you please check and advise me

Thanks.

[prakash11440278]

HI @sfaizee ,

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