Forum Discussion
Solved
Span of Control
Hi all, I have a table structured like this: Employee Manager 1 2 1 3 1 4 1 5 2 6 2 7 2 8 2 9 2 10 3 11 3 12 3 13 3 14 4 15 4...
You could simply add a new column with DAX:
Span of Control = VAR x = [Employee] RETURN CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', x = [Manager] ) )You should change the 'Table' with your table name.
Edit: You may add a " + 0" after the "COUNTROWS(TABLE)" in order to not display null results
Smauro
Solution Sage
Solution SageYou could simply add a new column with DAX:
Span of Control =
VAR x = [Employee]
RETURN
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', x = [Manager] ) )You should change the 'Table' with your table name.
Edit: You may add a " + 0" after the "COUNTROWS(TABLE)" in order to not display null results
I was battling with this same issue and this worked for me as well! Thank you!!!