Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

VAR DAX Measure

Fowmy 

May I take your help again. 

 

 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.  I dont know how to refer to it in my calcualtion. 

 

Below is my DAX measure:

 

 

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:

 Can you please help me.

 

Many Thanks!

Need Help
Show and Tell

5 Replies

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

    Anonymous , Syntax seems fine. But try to push filter to Fin Level map table

    Try like 

    Naturalinnerjoin(Holding), Calculatetable('Fin table Map', Fin_Level2= “Deposits and Current Account”) )

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Amit,

       

      I am getting this error after applying your syntax.

       

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

        Anonymous , no need of a filter, we plan to use calculatetable as the second table

         

        Var _fund = Naturalinnerjoin(Holding), Calculatetable('Fin table Map', Fin_Level2= “Deposits and Current Account”) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Amit Ji,

     

    I am still facing some error.

     

    • v-xiaotang's avatar
      v-xiaotang
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous 

      could you share your sample file & expected result? you can remove sensitive data and replace it with fake data. I'll modify your measure or recreate a new one later.

       

      Best Regards,

      Community Support Team _Tang

      If this post helps, please consider Accept it as the solution to help the other members find it more quickly.