Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

VAR SYNTAX DAX , Please Help!

  Hi Experts, I am creating a measure using var. The highlighted var _cash is not picking up in my calculation.  I noticed that during calculation var _cash is being ignored.  Can you anyone ...
Need Help
Show and Tell
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

I don't see where you're using __Cash. DAX will lazily ignore a variable if you never refer to it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Alexis,

 

I dont know how to refer var _Cash, Can you help in that.

 

Many thanks.

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    5 years ago

    What do you want to do with that variable? If you don't want to use it, why is it defined?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      My Requirement is:

      If Fin_Level2= “Deposits and Current Account” than Sum of market_value_in_usd per Customer_No for latest BusinessDate and create a band.

       

      The banding as follows