Percentage by the total

[tiagoaa1996]

Hi all,

I need help to make a calculation by the total of the filters by "CM / Budget", the measure that i created is doing a Sum of the percentage but what i need is a calculation of the total.

As below istead of 19.26% i need to see 2108 / 19991 = 10.5%

Budget	CM	My measure (wrong)
4.417	353	7.99%
15.574	1.755	11.27%

19.991

2.108

19.26% (Should be 10.5%)

Thanks for your help

[edhans · Accepted solution]

Use this:

% of Total = 
DIVIDE(
        SUM('Table'[CM]),
        SUM('Table'[Budget]),
        0
)