Power BI: In a Demographics Table find the count of times an Employee “ID” appears in the column “Supervisor ID” and return the count on the ID Row
I feel that i’ve gotten close but seem to be failing in grouping.
we have 23,000 employees all identified by a unique employee number (ONROLL[ID]). All employees (except the CEO) have a supervisor that is identified by their employee number (ONROLL[SUPV_ID]).