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

tamerj1's avatar
tamerj1
Community Champion
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] ) )
)