Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver 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]
    )
    )

     

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver I
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]
)
)