Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |