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 want to show manager's team(agents) performance compared to other team of same region.
Only card and one slicer is present in report. Slicer is of manager and card shows performance of its team as percentage.
Below is the sample data. Two tables are there.
Region | Manager_Name | Agent_Name |
East | Kevin | Apple |
East | Kevin | Mango |
Central | Louis | Banana |
Central | Louis | Orange |
East | Mark | Pineapple |
East | Lucas | Watermelon |
ID | Agent | Sales |
1 | Apple | 60 |
2 | Mango | 40 |
3 | Banana | 30 |
4 | Orange | 70 |
5 | Pineapple | 50 |
6 | Watermelon | 50 |
For example if manager "Kevin" is selected in slicer, then card should show value = (60+40)/(60+40+50+50) = 50%
---Kevin's team/Total sales within Kevin's region
Someone please help me in DAX
Please not percentage will be displayed in card.
Solved! Go to Solution.
Please consider the Manager_Name slicer coming from the DIM table (Agent_Name, Manager_Name, Region) and
in terms of model : one to many relationship on Agent_Name
if this solution answers your needs please mark it as a solution
Best regards,
Alex
Please consider the Manager_Name slicer coming from the DIM table (Agent_Name, Manager_Name, Region) and
in terms of model : one to many relationship on Agent_Name
if this solution answers your needs please mark it as a solution
Best regards,
Alex
Thanks Alex!
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 |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |