KPI Donut Chart

[sajarac]

Hello Community.

I had to stop doing some PowerBI reports for almost 2 years and it seems like I have to start from the beginning again.

Anyway.

I have a silly question and I would like to get an advice.

I have this visual KPI donut.

and It gives me a number like 1500000%

So I need first to fix that value, and second I need that number to be the percentaje over the total of my column.

I mean. Let's see I have a column name GrossPound.

I have a Measure = 

TotalGrossPounds = SUM('Database'[GrossPounds])

That is my single value.

But in my Database I have a column products

Product A

Product B

Product C

Product D

And the grosspounds is the sum of all those products

I want that visual to show only the percentage from product B compared with the sum of Products.

Make sense?

Thanks in advance for any help.

Regards

[sajarac]

You are absolutely rigth.

THANK YOU VERY MUCH!!

Fixed at the first try.

[FrankAT · Accepted solution]

Hi @sajarac ,

you can do it like this. Adapt the measure to your circumstances:

Percentage Measure =
DIVIDE(
    CALCULATE(SUM('Database'[GrossPounds]), Product = "B"),

    CALCULATE(SUM('Database'[GrossPounds]), ALL('Database'[Products])

)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)