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

amitchandak's avatar
amitchandak
Super User
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])