Forum Discussion

AlexanderRbt's avatar
AlexanderRbt
Icon for Helper I rankHelper I
4 years ago
Solved

Counting rows based on value on one column that is reference in another

  Hello   I have a table that contains managers and their employees. Employee name                Manager Name                  ID of managed team                   ID of my team ...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    AlexanderRbt 

    If my above assumption is true you may try something like 

    Count =
CALCULATE (
    COUNTROWS ( TabeName ),
    TREATAS ( VALUES ( TabeName[Manager Name] ), TabeName[Employee Name] ),
    REMOVEFILTERS ( TabeName )
)

    you may try it with or without the REMOVEFILTERS part

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

AlexanderRbt 

If my above assumption is true you may try something like 

Count =
CALCULATE (
    COUNTROWS ( TabeName ),
    TREATAS ( VALUES ( TabeName[Manager Name] ), TabeName[Employee Name] ),
    REMOVEFILTERS ( TabeName )
)

you may try it with or without the REMOVEFILTERS part

AlexanderRbt's avatar
AlexanderRbt
Icon for Helper I rankHelper I
4 years ago

Hello tamerj1 

 

I am trying to get your solution to work. I am not familiar with TREATAS and REMOVEFILTERS but both make sense in this context.

 

Thanks you for the gift of your time and your willingness to help a complete stranger.

 

Thanks

A.