Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 =
Solved! Go to 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)
You are absolutely rigth.
THANK YOU VERY MUCH!!
Fixed at the first try.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |