Substract of portion from Donut chart

[Anonymous]

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

[TaylorPBI21]

Hi @Anonymous ,

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

[Anonymous]

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.