Power BI Help with Matrix table in calculating % by employee hrs by site

[Lionel_Charley]

Team,

I am trying to do create a matrix table to plot Employee and Site in rows and total hrs and % of total hrs just for the specific employees in values.

When i plot this in power bi i get all rows 100% as seen in coloumn D. I would like to get the result as shown in coloumn E.

[JW_van_Holst · Accepted solution]

 Measure:

_pct of employee hours = 
DIVIDE(
    [_total hours], //_total hours = sum(hours)
    CALCULATE(
        [_total hours],
        ALL('Table'),
        VALUES('Table'[Employee])
    )
)