Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

AR Aging Amount after adding RATE not working

Hi All   I have below expression working fine :- AR_AMT_ = if(sum(AR[AR_AMT]) =0 , blank(),sum(AR[AR_AMT]))   When i add above expression with RATE , it does not work :- AR_AMT_SGD = if(divide(...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on your description, you can create a measure as follows.

    _rate = SUMX(FILTER('RATE',[SOURCE]=SELECTEDVALUE('AR'[SOURCE])),[RATE])
    Result:
     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

     

     
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Thanks for your reply.

    In table “AR”, there are only two values(TS and TI) in "Source" field. So TA and TP display NULL.

     

    Best Regards,

    Yuna

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Based on your description, you can create a measure as follows.

_rate = SUMX(FILTER('RATE',[SOURCE]=SELECTEDVALUE('AR'[SOURCE])),[RATE])
Result:
 

Hope that's what you were looking for.

Best Regards,

Yuna

 

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

 

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Yuaj

    Thank you very much , it work for SOURCE = TS AND TI now , but SOURCE = TA and TP display null.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

       

      Thanks for your reply.

      In table “AR”, there are only two values(TS and TI) in "Source" field. So TA and TP display NULL.

       

      Best Regards,

      Yuna

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Yuaj

        thank you very much , you are very sharp . I just check . It does not load all the 4 raw data file , some how folder name suddenly change . I need to reload again from zero.