I am using Rand() function to create a table. The problem is everytime I close the .pbix and then open it again, even if I don't refresh any data, just by openning it, the table is recalculated according to that Rand. How can I avoid that? I am using it to create Control Groups and need them to remain the same across time.
Below there is an example of the code in case it helps, very simple.
Thanks a lot in advance for the help!
Tabla Base Audiencia Extended Care_CONTROL_GROUP Inter =
VAR ExtendedCare_Audiences =
COUNTROWS ( 'Tabla Base Audiencia Extended Care Inter' )
VAR SampleSize = ExtendedCare_Audiences * 0.1
VAR TableWithRand =
'Tabla Base Audiencia Extended Care Inter',
TOPN(SampleSize, TableWithRand, [Rand])