Forum Discussion
KPI Donut Chart
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 =
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)
2 Replies
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)You are absolutely rigth.
THANK YOU VERY MUCH!!
Fixed at the first try.
