Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
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...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Antonio_Gomez's avatar
    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]
    )
    )

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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]
)
)

  • Antonio_Gomez's avatar
    Antonio_Gomez
    Resolver I
    4 years ago

    Hello amitchandak 

     

    Thanks for your participation. But, is still wrong