Forum Discussion

dw700d's avatar
dw700d
Post Patron
3 years ago
Solved

combining multiple columns into one column for a table visual

I have a table of employees. That table shows a hierarchy of who each employee roles up to in the organization. So for example in row 1 Dan reports to his Director Tina. Tina reports to her Vice pres...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi dw700d 

    you may try to add a calculated table like:

    Table = 
FILTER(
    UNION(
        ADDCOLUMNS( VALUES(data[President]), "Count", CALCULATE(COUNTROWS(Data))),
        ADDCOLUMNS( VALUES(data[Vice President]), "Count", CALCULATE(COUNTROWS(Data))),
        ADDCOLUMNS( VALUES(data[Director]), "Count", CALCULATE(COUNTROWS(Data)))
    ),
    [President]<>BLANK()
)

     

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi dw700d 

you may try to add a calculated table like:

Table = 
FILTER(
    UNION(
        ADDCOLUMNS( VALUES(data[President]), "Count", CALCULATE(COUNTROWS(Data))),
        ADDCOLUMNS( VALUES(data[Vice President]), "Count", CALCULATE(COUNTROWS(Data))),
        ADDCOLUMNS( VALUES(data[Director]), "Count", CALCULATE(COUNTROWS(Data)))
    ),
    [President]<>BLANK()
)