Random Values Aggregation

[Anonymous]

Hi,

I hope everyone is doing well.

I am generating two random numbers as follows:

Measure1 = var a = Calculate(Rand()*10) return a

Measure2 = var b = Calculate(Rand()*20) return b

whenever i try to subtract these numbers e.g.

Measure3 = Measure1 - Measure2

or

Measure3 = var c =Calculate(Measure1 - Measure2) return c

It doesnot give me the right answer.

Please help

[AllisonKennedy]

I'm also not sure what your end goal is, but you may find it useful to create or insert parameters in Power BI Desktop using the built in button or the GENERATESERIES DAX to then create slicers and what if analysis:
https://www.youtube.com/watch?v=a3Wn5s56mgo

[Anonymous]

Hi @AllisonKennedy ,

Yeah, I am trying to do whatif analysis but on random values. It is not producing the right results.

As you can see the result(EBIT0) is not correct.

Formula: 

EBIT0 = [Vdp0_rand]-[Cons0_rand]-[Cserv0_rand]-[Clav0_rand]-[Gbt0_rand]-[Amm0_rand]

Vdp0_rand = RAND()*([Vdpmax0]-[Vdpmin0])+[Vdpmin0]

Vdpmax0 = (1+SELECTEDVALUE(maxVdp0[maxVdp0]))*SUM(Input[Vdp0])

Vdpmin0 = (1+SELECTEDVALUE(minVdp0[minVdp0]))*SUM(Input[Vdp0])

maxVdp0 = GENERATESERIES(-1, 1, 0.01)

[v-xuding-msft]

Hi @Anonymous ,

If you make sense, can you please accept the helpful answers as solution? Others who have the same questions will find answers esily and quickly. They will benefit from your thread. 😉

[AllisonKennedy]

Are you able to use slicers instead of Rand()?

As @Fowmy mentioned, RAND is volatile function and recalculates not always as you would expect.

To see if that is the problem, please try adding a test measure as a value to the matrix in your screenshot:

RandCalcTest = [Vdp0_rand]

[Pragati11]

HI @Anonymous ,

Can you share more detail here why you think this is wrong?

Thanks,

Pragati

[amitchandak]

@Anonymous , what is the problem?

[Fowmy · Accepted solution]

@Anonymous 

Since you use RAND function, it always generates a new number at the time computation. It doesn't store the values and its  not static.
Let me know what you are trying to achieve.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn