Forum Discussion
AR Aging Amount after adding RATE not working
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.
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
Hi Anonymous ,
Sorry, it's still not clear. Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
Best Regards,
Yuna
Hi Yuaj
Thank you for wanted to help me.
Now my Rate work for Sales Table also Inventory Table But not work for AR Table.
Above is the link for my PBI file
Paul
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.
Hi Yuaj
Thank you very much , it work for SOURCE = TS AND TI now , but SOURCE = TA and TP display null.