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.
My objective is to present a report which shows each agent’s name, the total sales amount for that agent for the month and the commission earned based on the commission policy.
Here is more context for you:
Please find data set here: https://docs.google.com/spreadsheet...ouid=104129043494164133703&rtpof=true&sd=true
https://docs.google.com/spreadsheet...ouid=104129043494164133703&rtpof=true&sd=true
https://docs.google.com/spreadsheet...ouid=104129043494164133703&rtpof=true&sd=true
And
pbix: https://drive.google.com/file/d/1dGgyQ185t5uJjGZgNPbNyw71jVWvkHLu/view?usp=sharing
good day did you manage to find the answer i have same problem which i need solution
Hi @Yrstruly2021 ,
How to use the fowllowing three datasets? Why don't you add them into the pbix file? Could you please provide a similpe sample about how to calculating? Providing so many words caused my whole person to be confused.
How to Get Your Question Answered Quickly
It is best to provide the output you want in image form.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |