how calculate percentage and overall percantage for specific value in Table

[Anonymous]

Hi All,

I'm new to PowerBI awsome tool, but I'm facing an complexity to create the follwing chart:

Table:

Requirment are two chart to show the follwing, ( I did it manually in excell to show what I need ) :

1- first Donut chart(or any related) to show utilization for specific Type "ex, Laptop" from overall Total Qty after select it:

2- Second chart to show the  percantage  to see utilized qty from it's total not overall total, as follwing:

apprertiate your support

Thanks,

[parry2k]

@Anonymous you need to create a seperate table for slicer which is not linked to your main table and based on the selected value from this slicer, you need to create measures

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

thanks, but I need more clarification with steps for both mentioned scenarios:

1-utilization from type

2- overall utilization.

Note,  I have alot of Types not just the mentioned above, it just a sample from huge report

[parry2k · Accepted solution]

@Anonymous solution attached, you can tweak it from here.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k  can you please check the second chart as I need the remaining from selected not the selected value,

in our example Laptop the chart should contain 30 utilized and 4 remaining ( 34-30=4)

Thanks

Also, what if I added another slicer how to link it work like the first one.?

Thanks

[Anonymous]

Many thanks,

 what if I need to exclude specific filtered value from total measure,

Ex, if I need the total is total of all "Type" Column except "PC" .

Finllay, many thanks for your great effort, much appretiated

as I'm still beginner, could you please provide me any toturial  that explain this measurs.

[parry2k]

@Anonymous Let me know what is not clear in the measure and I will be more than happy to provide the input.

[Anonymous]

thanks@parry2k 

what I mean

if I need change total formula to be specific number?

also if I need the total value based on filter (Ex, total value =sum of all types excluding "PC"

another thing, how add some thing to number lable in chart to be for example (30 core) not just 30.

-