I have an issue that the negative values in the NetAmount Column are not coming up correctly on sum

[azeemnazim]

The total sum of NetAmount with respect to Item Code for date slicer is not comming up correctly when compared to calculating the sum output manually  mainly for 'D' Item Code i tried evrey thing but i am not able  to deduce a satisfying solution Please Help

Objective :-	Create a date parameter and basis the selection of date, all analyes of dashboard should update
Requirement :-	Display a date parameter in the Dashboard offering flexibility to users to see a dashboard as on particular date
Scenario :-	Date selected - 31/01/19
	Create a bar diagram summarizing Item Code wise Net Amount for transactions on or before 31/01/19 under Date Column
	Simultaneously, plot another graph summarizing all transactions due on or before 31/01/19 basis Due Date Column
Data :-
Date	Due Date	Item Code	Net Amount
05-10-2018	04-11-2018	A	2,00,000
05-10-2018	04-11-2018	B	50,000
05-10-2018	04-11-2018	C	1,50,000
21-11-2018	21-12-2018	A	2,84,200
21-11-2018	21-12-2018	B	2,00,000
22-12-2018	21-01-2019	A	7,86,135
04-01-2019	03-02-2019	B	1,84,200
01-01-2019		D	10,00,000
12-02-2019		D	12,00,000
18-02-2019		D	13,00,000
06-03-2019		A	-1,85,500
29-01-2019		D	-36,29,993
13-02-2019		D	-77,604

[v-kelly-msft]

Hi @azeemnazim ，

It's a measure total issue, if you couldn't get help from what is provided by @Greg_Deckler ,could you pls upload your .pbix file to onedrive business and share the link with me?Do remember to remove the confidential information.

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[azeemnazim]

Hi,

It would be very helpful if the objective in the question can be met , Just for you information i am getting wrong values for the item code 'D' on the dates in march , Moreover i tried the solution provided above but it didn't helped me much . I am stuck on this from a long time it would be very helpful if you could provide a solution to this

Many Thanks !!

Please find the desired path below

PATH :https://1drv.ms/u/s!AlF3e3HLnNPIa3eOMd9DyD_l4BU?e=fBUHyL

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[azeemnazim]

Hi ,

The Value of th NetAmount for  Item code D is Highlighted in the attached Screenshot is not comming up correctly , I tried your solution but it didn't helped

[v-kelly-msft · Accepted solution]

Hi  @azeemnazim ,

Is below pic your expected output?

Create a measure as below:

Measure 2 = CALCULATE(SUM('Net_Amount'[Net Amount]),FILTER(ALL(Net_Amount),'Net_Amount'[Item Code]=MAX('Net_Amount'[Item Code])))

If it's not what you need,pls advise me your expected output.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!