CALCULATE % of TOTAL value

[Anonymous]

Hi Pbi expert

i need to calculate a % value og each row based on total.

eg:  i want to calculate value as showed down in red

How can I reach such calculation ? 

categ.	Count
M-5	20	25%
M-4	19	24%
M-7	15	19%
M-3	13	16%
M-6	12	15%
Total	79

[v-jianboli-msft]

Hi @Anonymous ,

Based on your description, please try:

Percentage = DIVIDE(COUNT('Table'[categ]),CALCULATE(COUNT('Table'[categ]),ALL('Table')))

Change the format:

Final output:

Best Regards,

Jianbo Li

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

[djurecicK2 · Accepted solution]

Hi @Anonymous ,

 You can try adding the count to the matrix again but then setting the field to show as % of grand total.

Please accept as solution if this answers the question- thanks!