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 all,
I have some data that consists of a wholesaler and sales reps attached to each wholesaler. Different wholesalers have a different number of sales rep attached to them. Each sales rep has a daily target of 35 visits. I need to show these daily targets against the wholesaler.
What DAX formula could I use to achieve this? Thank you.
Wholesaler | Sales reps attached | Target per Sales rep | Targets |
A | 2 | 35 | 70 |
B | 3 | 35 | 105 |
C | 4 | 35 | 140 |
D | 5 | 35 | 175 |
E | 4 | 35 | 140 |
Solved! Go to Solution.
@Kaskazi_Network , Is that product of two columns ??
New column
rep Targets= [Sales reps attached]* [Target per Sales]
@Kaskazi_Network , Is that product of two columns ??
New column
rep Targets= [Sales reps attached]* [Target per Sales]
hi @Kaskazi_Network - Please look at the below steps to achieve the same using DAX
You need to create the below 3 measures to achieve the desired result.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
The last column shows Wholesaler Targets
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |