Percentage of used capacity of coworkers (problematic data)

[jakubmateju]

Hello everyone,

I would like to ask for help. I am trying to make a report which would show used capacity of my coworkers. But i am getting data from excel in the form of digit 1 as filled day and digit 0 as a free day for work.

I need to make visualisation of used capacity per worker and as whole team as percentages capacity utilization. I have data in this form:

data

And i am trying to vizualize workloud in % per worker. I was trying gauge but i cant figure out how to show a goal (cca 97 % of total) and the most importantly the percentage of days which are used for work. Vizual here: 

I would apreciate any help or tips very much.

[v-yulgu-msft]

Hi @jakubmateju,

Based on my assumption, maybe you could try this measure:

Percentage =
CALCULATE (
    COUNT ( table[Days in work] ),
    FILTER ( ALLEXCEPT ( table, table[Jmeno] ), table[Days in work] = 1 )
)
    / CALCULATE (
        COUNT ( table[Days in work] ),
        FILTER ( ALL ( table[Jmeno] ), table[Days in work] = 1 )
    )

For more advice, please show us your desired result. And tell us which columns should be used and what the calcution rule should be. 

Regards,

Yuliana Gu