cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kaytrishjr
Frequent Visitor

How to calculate the percentage of a total

I am using a matrix and trying to get the percentage of the total and can't seem to get the right equation for the effort part in yellow. 

 

This is what I'm trying to achieve;

kaytrishjr_0-1631297925692.png

This is what I used

kaytrishjr_2-1631298258640.png

 

Thanks for your help!

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @kaytrishjr ,

 try this measure:

Effort =
DIVIDE(
CALCULATE( SUM( 'Tablename'[Sum of Hours] ) )
, CALCULATE( SUM( 'Tablename'[Sum of Hours] ) , ALL( 'Tablename'[Speedtype] ) )
)

If this does not work, please take the time and create a Power BI Desktop file that contains sample data but still reflects your data model. Create the data using the manual input data. Upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

 

Nevertheless, I hope the measure above provides what you are looking for.

 

Regards,

Tom

 



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

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
kaytrishjr
Frequent Visitor

You rock!!! It worked and thanks for you help and quick response.

TomMartens
Super User
Super User

Hey @kaytrishjr ,

 try this measure:

Effort =
DIVIDE(
CALCULATE( SUM( 'Tablename'[Sum of Hours] ) )
, CALCULATE( SUM( 'Tablename'[Sum of Hours] ) , ALL( 'Tablename'[Speedtype] ) )
)

If this does not work, please take the time and create a Power BI Desktop file that contains sample data but still reflects your data model. Create the data using the manual input data. Upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

 

Nevertheless, I hope the measure above provides what you are looking for.

 

Regards,

Tom

 



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

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.