AR Aging Amount after adding RATE not working

[Anonymous]

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([SALES_],'RATE'[RATE_]) =0 , blank(),divide([SALES_],'RATE'[RATE_]))

Can some one share wth me how to make it work ?

Paul

[Anonymous · Accepted solution]

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]

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

[Anonymous]

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.

https://www.dropbox.com/s/5n6zhqrfqs42ip2/PBT_V2021_88%20ROW%2050%20solve%20AR%20rate%20wrong.pbix?d...

Above is the link for my PBI file

Paul

[Anonymous · Accepted solution]

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]

Hi Yuaj

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

[Anonymous · Accepted solution]

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]

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. 

[amitchandak]

@Anonymous , I doubt that you join with the rate table is not correct. If they from a different table, they should be measures

A measure  divide([SALES_],[RATE_], blank)

Should work.  But seem like there some issue with rate or sales , because of screenshot

[aj1973]

Hi @Anonymous 

Try this:

AR_AMT_SGD =

Var SalesByRate = divide([SALES_] , [RATE_] , 0)

Return

IF(SalesByRAte = 0 , blank() , SalesByRate)

[Anonymous]

Hi AJ

I just try , it return the same wrong result :-

[aj1973]

Paul,

Sorry but you are not telling us what do you want to achieve!! more details would be more helpfull and sharing a PIBX would be even better.

[littlemojopuppy]

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