Forum Discussion
Error adding Columns (Sum)
Hello Everyone,
Here I'm again with doubts and errors 😞
In the following table the "Total" column is not adding well, as you can see for example Fishing is shown 90 instead of 97 which would be the correct result.
My formula is:
- In the same table I have a column with Ports but some of them are blanks, that's why I putted HASONEVALUE(V_HistoricalBbox[PUERTOS.PortNAME])
- CantBuquesTotales = DISTINCTCOUNT(V_HistoricalBbox[VesselId]). As I'm counting the differents Ids for the column VesselId.
This table shows the differents ships that call at these ports
The sum of the rows is OK, the problem is adding the columns
.
Well v-luwang-msft amitchandak I found the solution
First, I rearranged the tables. Because one table contained several merges of others and from this super table the data was being extracted.
So, in this new arrangement with separable tables I applied this formula:
CantBuquesTotCorr = IF(HASONEVALUE(PUERTOS[PortLOCODE]),[CantBuquesTotales],SUMX(VALUES(PUERTOS[PortLOCODE]),[CantBuquesTotales]))
6 Replies
Antonio_Gomez , Ideally we should add column visual, add type and check
CantBuquesTotCorr = IF(
HASONEVALUE(V_HistoricalBbox[PUERTOS.PortNAME])
,[CantBuquesTotales]
,COUNTX(
Summarize(V_HistoricalBbox,V_HistoricalBbox[VesselId],V_HistoricalBbox[TYPE])
,[CantBuquesTotales]
)
)Hi Antonio_Gomez ,
Test the below,and if still not work ,could you pls share a sample data,and remember remove confidential data.
CantBuquesTotCorr = IF ( HASONEVALUE ( V_HistoricalBbox[PUERTOS.PortNAME] ), [CantBuquesTotales], SUMX ( V_HistoricalBbox, [CantBuquesTotales] ) )And refer:
https://archerpoint.com/how-to-make-measures-total-correctly-in-power-bi-tables/
https://community.powerbi.com/t5/Desktop/Wrong-column-totals-table/m-p/565904
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Hi Antonio_Gomez ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
LucienWell v-luwang-msft amitchandak I found the solution
First, I rearranged the tables. Because one table contained several merges of others and from this super table the data was being extracted.
So, in this new arrangement with separable tables I applied this formula:
CantBuquesTotCorr = IF(HASONEVALUE(PUERTOS[PortLOCODE]),[CantBuquesTotales],SUMX(VALUES(PUERTOS[PortLOCODE]),[CantBuquesTotales]))
