Forum Discussion

Resolver I

4 years ago

Solved

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...

Antonio_Gomez
4 years ago
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]
)
)

v-luwang-msft

Community Support

4 years ago

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 Regards

Lucien

Antonio_Gomez

Resolver I

4 years ago

Sorry v-luwang-msft didn't work.

This is the result with your formula