Forum Discussion
Total Sum Not adding up for specific rows
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
Anonymous
If that is not possible we have to force a row contxt likeSumx(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]
6 Replies
Anonymous
If that is not possible we have to force a row contxt likeSumx(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 , Please mark the reply as a solution.
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 ForumHi,
Share the link from where i can download your PBI file.
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
