Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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 , 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!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |