Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Ok, so I am working on a new team based commission tracker and need some helpcreating some measures.
Hope this makes some sense!
Problem 1:
If the store achieves $25k gross profit, a commission pool of 2.5% of the stores gross profit becomes available to be shared with the staff based on their individual contribution. If the store achieves $30k this becomes 5% and then $35k, this becomes 6%. I want a formula that will show the "Commission pool" for both stores for the particular week selected (there is a calculated column for "Week Ending". You can see this illustrated in the visual at the top of the page.
Problem 2:
I then need a measure that calculates staff "Gross Profit Contribution" for their particular store. I already have this in the matrix visual showing the right information, however it needs to be a measure so I can then calculate their earnings out of the commission pool.
Hi,
Share the link from where i can download your file and more importantly show your expected result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |