Calculate percentage of sub-categories

[WAKAYN]

Hello Everyone,

Appreciate it if you could please share how I can get the percentage of the sub-totals (Year1% and Year2%) in this table:

	Year1	Year1 %	Year2	Year2 %
Region1	100	100%	110	100%
Sub-Region1.1	65	43%	70	64%
Sub-Region1.2	35	23%	40	36%
Region2	150	100%	160	100%
Sub-Region2.1	45	30%	50	31%
Sub-Region2.2	55	37%	60	38%
Sub-Region2.3	50	33%	50	31%

Thank You.

[tamerj1 · Accepted solution]

Hi @WAKAYN 
Please refer to attached sample file with the solution

Amount = SUM ( 'Table'[Value] )

% Amount = 
DIVIDE ( 
    [Amount],
    CALCULATE ( [Amount], ALL ( 'Table'[Sub-Region] ) )
)

[WAKAYN]

Thank you so much, tamerj1. This worked like a charm.

Thanks also to others who looked into this.

[WAKAYN]

Sorry, pleae see corrected table below (Sub-Region 1.1, 1.2, etc. and some values are fixed):

	Year1	Year1 %	Year2	Year2 %
Region1	100	100%	110	100%
Sub-Region1.1	65	65%	70	64%
Sub-Region1.2	35	35%	40	36%
Region2	150	100%	160	100%
Sub-Region1.1	45	30%	50	31%
Sub-Region2.2	55	37%	60	38%
Sub-Region2.3	50	33%	50	31%

Thank you.

[FreemanZ]

this is the expected result. how is your dataset organized?