Forum Discussion
Pass measure value to a dax function variable
I have a what - if-parameter :
Vals = GENERATESERIES(1, COUNTA(Sale[Row ID]), 1)
Count = SELECTEDVALUE('Table 1'[Vals])
Now the data in count needs to be passed to var size of below dax function .. how is that possible
Rand Function Table =
VAR Size = 12
VAR TableWithRand =
ADDCOLUMNS ( Sales, "Rand", RAND () )
RETURN
TOPN (Size, TableWithRand, [Rand] )
2 Replies
- az38
Community Champion
Hi Anonymous
if I understand you correct didnt you try simple
Rand Function Table = VAR Size = SELECTEDVALUE('Table 1'[Vals]) VAR TableWithRand = ADDCOLUMNS ( Sales, "Rand", RAND () ) RETURN TOPN (Size, TableWithRand, [Rand] )?
