Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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.
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |