Forum Discussion

lawada4's avatar
lawada4
Frequent Visitor
3 years ago
Solved

total sum value in table visual is wrong

im trying to calculate the total commission by all salespersons. i have 2 tables , one table shows the commission by catgory and the other table shows sales transactions by salespersons.   i create...
"Need Help"
@Daxhelp
@get help
@Please Help
Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi lawada4 

    please try

    Total Commission =
    SUMX (
    SUMMARIZE (
    'categories trans',
    'categories trans'[AGENT_NAME],
    'categories trans'[Category]
    ),
    CALCULATE ( SUM ( 'categories trans'[Commission] ) )
    )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  lawada4 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards