Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incorrect Total in Table

Hi guys,    I have exactly the same problem shown in the example below.   The TOTAL is not adding up the 'duplicate' values in the table (In the example: 3+3+5+5+2 = 18). The TOTAL is only ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , make sure you are using sales person from table1 and then check

     

    else try this measure

    sumx(summarize(Table1,Table1[Date], Table1[Sales Person], "_1", sum(Table2[Amount]])),[_1])

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    I do not know what is the logic how to calculate those, but I just tried to simply multiply two values.

    Please check the measures down below. If the logic is incorrect, then you can simply change the multiplier to your correct logic.

     

    HS AS Total =
    SUMX (
    RELTMS,
    RELTMS[Hours]
    * LOOKUPVALUE (
    Actuals__022021[HS A/S],
    Actuals__022021[%Chave_RELPRJ], RELTMS[%Chave_RELPRJ]
    )
    )
     
    Sizing Total =
    SUMX (
    RELTMS,
    RELTMS[Hours]
    * LOOKUPVALUE (
    Actuals__022021[SIZING],
    Actuals__022021[%Chave_RELPRJ], RELTMS[%Chave_RELPRJ]
    )
    )
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.