Forum Discussion
Solved
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 d...
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 , 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!
