Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 f...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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] )

? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you so much for the reply.Tried giving the same , but it wasn't working.