table visual summing total wrong

[lawada4]

im trying to calculate commission by each agent according to pack he sold and number of transations by pack, the problem is im when im multiplying the pack commission by number of transactions it's doing the same multiplication forthe overall total transactions and the overall commssion tota which which is resulting in wrong total commission for the agent. in the screenshot  the total commission should be 124.305 instead of 3908.21

the measure im using:

CALCULATE(COUNT('categories trans'[revenue]) * SUM('categories commision'[Commission]),

    GROUPBY (

        'categories trans',

        'categories trans'[AGENT_NAME],

        'categories trans'[Categoty],

        'categories trans'[Commitment],

        'categories trans'[BASE_TYPE],

        'categories trans'[revenue]

    ))

note: the data model consists of two table : trancations table by agents and commission pack by category

[amitchandak · Accepted solution]

@lawada4 , try a measure like

Sumx(
Summarize(
'categories trans',
'categories trans'[AGENT_NAME],
'categories trans'[Categoty],
'categories trans'[Commitment],
'categories trans'[BASE_TYPE],
'categories trans'[revenue],
"_1", COUNT('categories trans'[revenue]) * SUM('categories commision'[Commission]) )

,[_1]
)
))

[lawada4]

the measure solved the issue . thanks!