topic Re: Random Number in DAX Commands and Tips

Random Number

Anonymous — Mon, 23 Sep 2024 08:38:09 GMT

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.

Re: Random Number

dharmendars007 — Mon, 23 Sep 2024 11:29:30 GMT

Hello Anonymous ,

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

Re: Random Number

Anonymous — Tue, 24 Sep 2024 02:34:52 GMT

Hi Anonymous

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.