Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Saes
Helper I
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) 

 

AreaTargetPerson 1Person 2Person 3Person 4
Area 1At or Below52.3%29.9%7.3%0.3%
 Above47.7%70.1%92.7%99.7%
Area 2At or Below93.7%62.2%62.8%20.0%
 Above6.3%37.8%37.2%80.0%
Area 3At or Below81.9%63.0%16.5%13.5%
 Above18.1%37.0%83.5%86.5%
Area 4At or Below94.9%95.6%33.8%1.6%
 Above5.1%4.4%66.2%98.4%



Can anyone help?

1 ACCEPTED SOLUTION
Sahir_Maharaj
Super User
Super User

Hello @Saes,

 

Can you please try this:

 

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
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

View solution in original post

1 REPLY 1
Sahir_Maharaj
Super User
Super User

Hello @Saes,

 

Can you please try this:

 

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
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors