Forum Discussion
table visual summing total wrong
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:
note: the data model consists of two table : trancations table by agents and commission pack by category
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]
)
))
2 Replies
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]
)
))the measure solved the issue . thanks!
