Straight Table total amount unable to display even i hv activated

[admin11]

[manikumar34]

@admin11 , I see you already have amt_on_hand and rate as sperate measures. You can directly divide them to get desired output. 

DIVIDE([Amt_on_hand],[rate],0)

Regards, 

Manikumar

[Paulyeo11]

Hi Mani

I am still getting total amount =0

[ebeery]

@admin11 the DAX DIVIDE function is "safe divide".  This means that when it encounters a divide by 0 situation, it will return an "alternate result".  The default alternate result is BLANK.  

I suspect that the reason you are not seeing a total is because your formula is encountering a divide by 0 error in the total row, and consequently returning the default alternate result of BLANK in that row.

You could confirm this quickly by providing an alternate result in your measure, such as below.

AMT_ON_HAND_SGD_ = Divide(SUMX(INVC, INVC[UNIT_COST]*INVC[QTY_On Hand]), 'RATE'[_rate], "test alternate result")

https://docs.microsoft.com/en-us/dax/divide-function-dax 

[admin11]

Hi eBeery

Thank you for sharing , So it is due to dievde by 0  ,it there any work aorund ?

[ebeery]

@admin11 I think you need to re-evalutate the portion of your formula that's causing the divide by 0 error (the 'Rate'[_rate] field).  

What is the value you would be expecting to be used in the calculation for [_rate] in the "Total" row?  A sum of rates?  An average of rates? 

[admin11]

Hi eBeery

i just try to multiple the rate to get SGD currency.

Paul

[Ashish_Mathur]

What measure have you written for _rate?

[admin11]

Hi ASH

Below is the link :-

https://www.dropbox.com/s/anpbamwypp9ratf/PBT_V2021_127%20how%20to%20make%20Total%20amount%20display...

Paul

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

Hope this helps.

[admin11]

Hi ASH

Thank you very much. 

Paul

[Ashish_Mathur]

You are welcome.

[Paulyeo11]

Hi Ash

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

Above is my _rate expression

Paul

[Ashish_Mathur]

Hi,

Why should we use a SUMX() function to calculate the rate.  Share the link from where i can download your PBI file.

[admin11]

Hi ASH

Thank you for sharing.

https://www.dropbox.com/s/wg2296kanregdcc/PBT_V2021_110%20solve%20AR%20Cannot%20display%20Total%20Am...

Above is my PBI file.

Paul

[Ashish_Mathur]

No file there.