Forum Discussion

redwings00's avatar
redwings00
Helper I
5 years ago
Solved

Direct - Indirect Report Help

Hello, I am looking for some assistance with showing Direct and Indirect reports.   This previous thread below provided a great start for myself but I am now trying to expand on this. https://com...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    redwings00 Easiest thing would be:

    Measure = IF(ISBLANK([Measure - Direct Reports]),BLANK(),LEN([Measure - Direct Reports]) - LEN(SUBSTITUTE([Measure - Direct Reports],",","")) + 1)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

redwings00 Like:

Measure - Direct Reports 1 = 
VAR __empid = MAX('Sheet1'[EMP ID])
VAR direct = FILTER(ALL('Sheet1'),[MANAGER ID] = __empid)
RETURN
    IF ( ISEMPTY ( direct ) = FALSE (), CONCATENATEX ( direct, [EMPLOYEE NAME], ", " ) )

I tell people not to use VALUES and CALCULATE but does anyone listen? 🙂

redwings00's avatar
redwings00
Helper I
5 years ago

Greg_Deckler  Thank you again Greg. Would you be able to help with the measure for the indirect names if possible?

I was not aware of the information regarding not to use VALUES and CALCULATE, but will definitely need to read it as I get more comfortable in power BI