PBI sum up Price column

[betty_bui2602]

Hello all, 

I have question regarding total value which take qty and unit price from 2 different table

I have AvgNetPrice raw data from in table Net_Price and Current Fcst from another table. My result per row is correct, but sum is not

Any idea how to solve. 

TIA 

[v-yalanwu-msft]

Hi, @betty_bui2602 ;

Glad to hear that you solved it, can you mark the proper reply as a solution to close the case?

Thank you!

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @betty_bui2602 ;

Can you share data from two simple tables? And their relationship, in general, we use sumx(summarize()) to correct total?

It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

Solved: How to upload PBI in Community - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[betty_bui2602]

I have resolve it with summarize(). 

Thank you 😉

[FarhanAhmed]

Change the Price Column/Field properties to "Do Not Summarize"

or change the aggregation to "Do Not SUmmarize"

[betty_bui2602]

Thank for respone, id tried it but total is not as what it should be. 

Market	Material	Avg(NetPriceUSD)	Sum of Lag 0Forecast	Current Fcst $
AUS	E1LM010000	29.9748	4446	133,268
NZL	E1LM010000	29.9748	324	9,712
JPN	E1LM010000	40.3357	250	10,084
TWN	E1LM010000	50.3971	880	44,349
IDN	E1LM010000	51.685	226	11,681
MYS	E1LM010000	51.685	1860	96,134
PHL	E1LM010000	51.685	70	3,618
SGP	E1LM010000	51.685	1053	54,424
VNM	E1LM010000	51.685	1080	55,820
THA	E1LM010000	57.1625	1900	108,609
HKG	E1LM010000	61.2474	4030	246,827
				774,526

My measure: 

sumx('Avg Net_USD','Avg Net_USD'[Avg(NetPriceUSD)]) * sumx('MTD Attainment'[currentForecast])