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 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'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.