Urgent!!!! I need quick help

[Sravan_cheni]

As seen in the above image rows indicates Type and column indicates work station and the values are the total units processed in a workstation based on the uph type (shown in %).

Now i need to create a new table in Power BI desktop as above (Note : not a visual i need to create a new table data)
Now i have Type, Workstation, Units, Units% on workstation.

Example 1: i have to create a new column showing for work station augtobag the top units processed Type is Autobag so i need Autobag for the workstation Autobag, 

example 2 : i have to create a new column showing for work station Flexible queues the top units processed Type is Heat Seal so i need Heat seal  for the workstation Flexible queues, 

Result should come as below

Please help me i have tried different scenarios but unable to achieve.

@truptis, @amitchandak, @johnt75, @lbendlin,@tamerj1, @Jihwan_Kim, @AlexisOlson,@PaulDBrown, @Vijay_A_Verma,@parry2k 

[tamerj1 · Accepted solution]

Hi @Sravan_cheni 
For the table you need to select the required columns from the original one and then add the measures as columns.

Table2 =
VAR SelectedTable =
    SELECTCOLUMNS (
        Table,
        "UPH_TYPE", Table[UPH_TYPE],
        "WORKSTATION (TIER 2)", Table[WORKSTATION (TIER 2)]
    )
RETURN
    ADDCOLUMNS ( SelectedTable, "Units_S", [Units_S], "% units", [% units] )

Then add a new calculated column

New Column =
VAR WSTable =
    CALCULATETABLE ( Table2, ALLEXCEPT ( Table2, Table2[WORKSTATION (TIER 2)] ) )
VAR MaxUnits =
    MAXX ( WSTable, Table2[Units_S] )
RETURN
    MAXX ( FILTER ( WSTable, Table2[Units_S] = MaxUnits ), Table2[UPH_TYPE] )

[Sravan_cheni]

Thank you @tamerj1 Thanks a Lot