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.
Hi guys.
I came up with a problem that has to do with sales targets and rate of achievement. So we have 2 business units (A and B). Every BU has its salesmen (x,y,z). Every salesman has monthly targets for sales. At the end of the month, we can calculate the achieved targets, meaning sales over target per month per salesman
So we can see that we achieved 3 of 6 targets, which gives a 50% success rate.
I want to create a calculated measure to calculate the success rate per BU per month (ignoring the salesmen). As we can see for 2022-7, business unit A had a target of 25E (10+15) and sold 24E (9+15), which gives a success rate of 0%. For 2022-8 with a total target of 38E sold 38E which gives 100% and so on. Is it possible to calculate the above?
Thank you in advance for your time!
Kostas
Solved! Go to Solution.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hey @kostask ,
I created a calculated column doing what you want :
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |