How to append columns in the same table and add a new column to create slicer?

[SelflearningBi]

I am new to powerbi. I got above table, I would like to make above table into following table, and create a slicer callled  Responsible which I could filter Apple, Banana, Peach. 

My Database(Above Table) doesn't include Resonsible either, how do I add this column and make orange column and green column append below yellow table? 

[v-luwang-msft · Accepted solution]

Hi @SelflearningBi ,

Pls refer the below:

base table:

Then use the below to calculate new table:

Table 2 = 
UNION (
    SELECTCOLUMNS (
        'Table',
        "Email", 'Table'[Email],
        "Job Tile", 'Table'[Job Title],
        "Name school", 'Table'[Name_School1],
        "telephone", 'Table'[Telephone],
        "Resonsible", "Apple"
    ),
    SELECTCOLUMNS (
        'Table',
        "Email", 'Table'[Email2],
        "Job Tile", 'Table'[Job Title2],
        "Name school", 'Table'[Name_School2],
        "telephone", 'Table'[Telephone2],
        "Resonsible", "Banana"
    ),
    SELECTCOLUMNS (
        'Table',
        "Email", 'Table'[Email3],
        "Job Tile", 'Table'[Job Title3],
        "Name school", 'Table'[Name_School3],
        "telephone", 'Table'[Telephone3],
        "Resonsible", "Peach"
    )
)

Then create the below measure:

color = IF(MAX('Table 2'[Resonsible])="Apple","Yellow",IF(MAX('Table 2'[Resonsible])="Banana","Orange","Green"))

Final Output result:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien