Forum Discussion

azakir's avatar
azakir
Resolver I
2 years ago
Solved

PATH() Error

Hi Guys.  I have the following table with Manager and Employee:    I would like to display it in a Matrix when the manager is expanded, it shows the staff reporting to the manager. Problem i...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  azakir ,

     

    Here are the steps you can follow：

    1. Create calculated column.

    Test =
var _select=SELECTCOLUMNS('Table',"Man",[Manager_DisplayName])
var _test1=
CONCATENATEX(
    FILTER(ALL('Table'),
    'Table'[Manager_DisplayName]=EARLIER('Table'[Manager_DisplayName])),[Employee],"|")
var _table1=
SUMMARIZE(
    'Table','Table'[Manager_DisplayName],
    "Employe11",
    CONCATENATEX(
        FILTER(ALL('Table'),
        'Table'[Manager_DisplayName]=EARLIER('Table'[Manager_DisplayName])),[Employee],"|"))
var _test2=
IF(
    'Table'[Employee] in _select ,
    MAXX(
        FILTER(_table1,[Manager_DisplayName] =EARLIER('Table'[Employee])),[Employe11]))
return
_test1 &"|"&_test2

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  azakir ,

 

Here are the steps you can follow：

1. Create calculated column.

Test =
var _select=SELECTCOLUMNS('Table',"Man",[Manager_DisplayName])
var _test1=
CONCATENATEX(
    FILTER(ALL('Table'),
    'Table'[Manager_DisplayName]=EARLIER('Table'[Manager_DisplayName])),[Employee],"|")
var _table1=
SUMMARIZE(
    'Table','Table'[Manager_DisplayName],
    "Employe11",
    CONCATENATEX(
        FILTER(ALL('Table'),
        'Table'[Manager_DisplayName]=EARLIER('Table'[Manager_DisplayName])),[Employee],"|"))
var _test2=
IF(
    'Table'[Employee] in _select ,
    MAXX(
        FILTER(_table1,[Manager_DisplayName] =EARLIER('Table'[Employee])),[Employe11]))
return
_test1 &"|"&_test2

2. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • azakir's avatar
    azakir
    Resolver I
    2 years ago

    thanks Anonymous that did the trick for me. Cheers for your help