Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community,
I know this is simple but can't get it to work, wonder what I'm missing.
How do I extract this information:
Handled Employees: is just the count of instance of the manager's name
% of Handled Employees = Handled Employees: over total population
Manager | Handled Employees | % of Handled Employees |
Recla, Kathlyn | 6 | 22.22% |
Strout, Walton | 7 | 25.93% |
Bonton, Carter | 3 | 11.11% |
Rena, Bradley | 5 | 18.52% |
Launt, Eulah | 6 | 22.22% |
Using this sample database (all names are fictitious, they are randomly generated):
Employee | Manager | Second Line Manager |
Mierow, Arla | Recla, Kathlyn | Newtown, Rebecca |
Greff, Roscoe | Recla, Kathlyn | Newtown, Rebecca |
Casumpang, Deangelo | Recla, Kathlyn | Newtown, Rebecca |
Czartoryski, Erlene | Recla, Kathlyn | Newtown, Rebecca |
Carota, Mario | Recla, Kathlyn | Newtown, Rebecca |
Blemel, Maxima | Recla, Kathlyn | Newtown, Rebecca |
Whittum, Lezlie | Strout, Walton | Newtown, Rebecca |
Blackson, Dorian | Strout, Walton | Newtown, Rebecca |
Hilyard, Kent | Bonton, Carter | Newtown, Rebecca |
Giacobbe, Tatiana | Bonton, Carter | Newtown, Rebecca |
Flaugher, Whitney | Strout, Walton | Newtown, Rebecca |
Varano, Foster | Strout, Walton | Newtown, Rebecca |
Willens, Meggan | Strout, Walton | Newtown, Rebecca |
Kaltved, Luann | Strout, Walton | Newtown, Rebecca |
Mckitrick, Clayton | Strout, Walton | Newtown, Rebecca |
Wigboldy, Lashunda | Rena, Bradley | Hardwood, Felix |
Garnand, Latrisha | Rena, Bradley | Hardwood, Felix |
Hebeisen, Willian | Rena, Bradley | Hardwood, Felix |
Nagelschmidt, Margot | Rena, Bradley | Hardwood, Felix |
Clausen, Lavonna | Rena, Bradley | Hardwood, Felix |
Steik, Cory | Launt, Eulah | Hardwood, Felix |
Rockholt, Adelina | Launt, Eulah | Hardwood, Felix |
Rissman, Gonzalo | Launt, Eulah | Hardwood, Felix |
Stumbo, Albert | Launt, Eulah | Hardwood, Felix |
Brague, Dalene | Launt, Eulah | Hardwood, Felix |
Pullus, Mignon | Launt, Eulah | Hardwood, Felix |
Erice, Ima | Bonton, Carter | Newtown, Rebecca |
Solved! Go to Solution.
Here are the Measures - this way you can control the names!
Handled Employees = DISTINCTCOUNT ( 'Table'[Employee] )
% of Handled Employees =
DIVIDE (
[Handled Employees],
CALCULATE ( [Handled Employees], ALLSELECTED ( 'Table' ) ),
0
)
Here are the Measures - this way you can control the names!
Handled Employees = DISTINCTCOUNT ( 'Table'[Employee] )
% of Handled Employees =
DIVIDE (
[Handled Employees],
CALCULATE ( [Handled Employees], ALLSELECTED ( 'Table' ) ),
0
)
The question was answered but I left off some details so I still have a followup question
How do I ignore the current context. For example if I do a drill down the percentage will not be the against GRAND TOTAL but instead against the total of the current context.
what if I do a drill-down graph from Second Line Manager to Manager(First Line) to Employee, I'm not seeing percentage out of the grand total but on for the total of the current filter.
Ok I think I got the answer myself... I just used the ALL keywork to unfilter everything this way even if I do filters the grand total stays the same, I don't know why they called it grand total but it reacts on filters, must be called sub-total then. Anyway I got it to work so I'm good for now. thanks again for your inputs guys, really appreciate it.
User | Count |
---|---|
85 | |
84 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |