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.