Random Number

[Antmkjr]

How can I use RANBETWEEN formula, but make it more stable, as everytime i open the report , it varies too much.

Eg: I am using RANDBETWEEN(90,210) but the variation should be minimum each time i open the report/refresh.

[Anonymous · Accepted solution]

Hi @Antmkjr 

Thank you very much dharmendars007 for your prompt reply.

The generation of random numbers focuses on randomness, so you want the RANDBETWEEN function to be more stable, which may defeat the meaning of randomness.

However, you might consider pre-generating a table of random numbers and using it in your report so that the random numbers are within the range of the pre-generated table on every refresh. For example:

"RandomNumbers"

Create a measure.

RandomNumber = 
VAR Index = RANDBETWEEN(1, COUNTROWS('RandomNumbers'))
RETURN
CALCULATE(
    FIRSTNONBLANK('RandomNumbers'[RandomValue], 1),
    FILTER('RandomNumbers', 'RandomNumbers'[Index] = Index)
)

Here is the result.

Regards,

Nono Chen

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

[dharmendars007]

Hello @Antmkjr , 

When you say resut should be minimum can you be more specific like coould you share a example like expected result..This will help us to check further.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN