Non-Summerized Percentages in Matrix Visual

[Grimfandango227]

Hello!

I am having trouble simply showing the Percentage of Overtime hours in the Total hours worked. Every time I add to the Matrix it Summarizes the totals and it is incorrect. Screenshots below. 

Please note that the column number is the week of year number and the Row headers are the departments. 

Any help would be greatly appreciated. 

Thanks!

Jeremy

[Anonymous · Accepted solution]

Hi @Grimfandango227 ,

First of all, thanks @Greg_Deckler  for the quick reply.

According to your description, you can try creating a measure and then placing the measure on the matrix.

OT % = SUM('Table'[OT Percentage])

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Greg_Deckler]

@Grimfandango227 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Grimfandango227]

Hi @Greg_Deckler , 

Thanks for the reply!

Example data as table below ↓↓

Dept.	Reg. Hours	OT Hours	Total Hours	OT Percentage
Blinker	2387.5	237.75	2619.25	9.08%
Maintenance	148	0	148	0.00%
Shipping	1343	105.75	1448.75	7.30%

I am having trouble getting the OT percentage into my visual in powerbi. I am using the Matrix visual; the issue is that it keeps summarizing the percentages and they appear wrong. 

Please note that the one aspect that is not included in my data example is that these are broken down by week. Screenshot below. 

Hopefully, this made more sense. Thanks again for the help!

Jeremy 

[Greg_Deckler]

@Grimfandango227 Well, it's likely using an implicit measure. You can change the implicit measure by clicking the dropdown for the column in the field well for the visual. Maybe Average is correct versus Sum.