Forum Discussion

giroldoale's avatar
giroldoale
Helper I
5 years ago
Solved

Variable not allowed

Hi, I'm pretty new into DAX formulas. I'd like to know the reason why in the formula reported into the screendshot there is no possibility to inser the variables of the table. I need to write a fo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi giroldoale ,

     

    In the measure, if you want to get the row value you will need to use SELECTEDVALUE() function.

    So your measure should be like:

    IF(SELECTEDVALUE(skip date)<>blank(),1,0)

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi giroldoale ,

 

In the measure, if you want to get the row value you will need to use SELECTEDVALUE() function.

So your measure should be like:

IF(SELECTEDVALUE(skip date)<>blank(),1,0)

 

Best Regards,

Jay