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

littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

Can you share some sample data, the expected result and a screen shot of what it is doing?