Matrix problem : Percentage ADDING instead of Percentage%

[Anonymous]

Good Morning,

Can someone tell me why my matrix is adding the Division totals instead of giving the % ?  Or if there is a workaround .....I have over 4 hours in this.  Thank you for any help

• Vendor%  is calculated by :  Vendors / Total Workers
• All the divisions below are correct for the Vendor %
• However, all the Names (E. Willie, D.Dave, C.Drew) are incorrect for the %.  Power BI is ADDING values instead of dividing (Example for E.Willie below, it says 2.82 instead of .663      It is adding  .60 +.69 +.64 + .89 = 2.82 instead of 324/488 = .663

[amitchandak]

@Anonymous , Have created a measure like

Divide(Sum(Table[A]), Sum(Table[B]) )

or

Divide(Sum(Table[A]), count(Table[A]) )

or are you summing up % column

[Anonymous]

Amitchandak,  Thank you for your help.  I got the solution, I was creating a column instead of a measure.........

[Anonymous · Accepted solution]

Hi,  Yes,  I am summing up as seen below: