Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello all,
perhaps the problem I'm having is so easy to solve but I'm struggling long time ago (Attaching a sample pbi for better understanding)
I have a table with real hours worked each month, those hours are classified by type (Internal, Lumpsum).
The lumpsum projects are the billable ones and the internal non billable. if the performance is 100% the chart looks like this
80% of the hours are billable and 20% are not.
Howver there is an additional columns called CV (Cost Variance) which basically tells the "trash" hours. which means I need to take those hours from out fromthe 80% billability and reduce it to a correct percentatge, the result should be looking like this if we take out 40h from the 80
the table I have has the following structure.
many thanks for the help!
Best regards
Hi @Abdel_BCN ,
I think I have the solution...
You will need 3 measures.
Measure 1 for the Total CV - Total CV = SUM(Sheet1[CV])
Measure 2 for the Total real Hours - Total Real H = SUM(Sheet1[Real h])
Measure 3 for Real Figure - Real Figure = [Total Real H] - [Total CV]
And here is the filters for the pie chart...
Hope this helped!
Many Thanks.
Taylor
Many thank for your reply Taylor,
the solution does not work since i want to keep the total hours as 100h.
The only thing that should happend is to take out 40h as cost variance from the Lumpsum projects and consider them as Non billable under another type called "cost variance".
So the distribution of hours would be : 60h non billable and 40h billables
thanks.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
120 | |
74 | |
72 | |
63 |