Total Sum Not adding up for specific rows

[Anonymous]

Hi, Need Help. My total sum for my Total Cost Column adds up correctly for 40HC "container size" but not for 40FT "container size". I am using one formula for my Total Cost column which is 

Total Cost = [Shipment Count] * SUM('FCL Pricing'[FCL Price]). The total cost for 40FT somehow is double the correct answer. See picture below. I also tried to just multiply HBL count or shipment count by FCL price and it still just doubles the cost only for 40FT. Any idea how to solve this?

[Icey]

Hi @Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please share me a dummy PBIX file, removing sensitive information.

Best Regards,
Icey

[amitchandak · Accepted solution]

@Anonymous 
If that is not possible we have to force a row contxt like

Sumx(Summarize(Table, Table[Origin], Table[Container Size], Table[CBM],Table[Shipment Count], "_max",Max('FCL Pricing'[FCL Price])),[Shipment Count]*[_max])

I can not tell you the best combination without looking at data. What all should be there in the group by of summarize

Should max be there Max/Average/SUM etc for 'FCL Pricing'[FCL Price]

[Anonymous]

Thank you all for your help. Amitchandak's formula solved it. Thank you Amitchandak.

[amitchandak]

@Anonymous , Please mark the reply as a solution.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[edhans]

I don't know what [Shipment Count] is. I suspect you need to be using SUMX() and not SUM() here, but without more context as to what is going on, difficult to know.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum