cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Percentage Measure by Row Category

Hi all,

Can someone help, as I'm struggling with what I think is basic measure. I'm using a matrix table to produce the following table, but I cannot get the percentages to work. The table will show me the correct values, when I try convert them to a %, it is not working.

For each person I need to show how the proportion that is 'above' and 'at or below' target for each area. All the data is in one table, with the following fields:

Area = RegionArea

Target = TargetResult

Person = SalesPerson

Result = Count (numeric)

 Area Target Person 1 Person 2 Person 3 Person 4 Area 1 At or Below 52.3% 29.9% 7.3% 0.3% Above 47.7% 70.1% 92.7% 99.7% Area 2 At or Below 93.7% 62.2% 62.8% 20.0% Above 6.3% 37.8% 37.2% 80.0% Area 3 At or Below 81.9% 63.0% 16.5% 13.5% Above 18.1% 37.0% 83.5% 86.5% Area 4 At or Below 94.9% 95.6% 33.8% 1.6% Above 5.1% 4.4% 66.2% 98.4%

Can anyone help?

1 ACCEPTED SOLUTION
Super User

Hello @Saes,

1. Create a Base Measure for Count:

``Total Count = SUM(Table[Result])``

2. Calculate the Percentage

``````Percentage =
DIVIDE(
[Total Count],
CALCULATE([Total Count], ALL(Table[TargetResult]))
)``````

With these measures and setup, you should be able to achieve the desired output. Should you require my further assistance, please do not hesitate to reach out to me.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning
Super User

Hello @Saes,

1. Create a Base Measure for Count:

``Total Count = SUM(Table[Result])``

2. Calculate the Percentage

``````Percentage =
DIVIDE(
[Total Count],
CALCULATE([Total Count], ALL(Table[TargetResult]))
)``````

With these measures and setup, you should be able to achieve the desired output. Should you require my further assistance, please do not hesitate to reach out to me.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning