Sums for filtered out values "Other"

[mengna]

Hi there,

Assuming I want to filter out a few out of many customers in a data set (C1-C1000), and I want subtotals like below, how do I create the "Total" and "Total of other customers" calculations? Any help would be greatly appreciated!

	Revenue	% of Rev (rev / total of all customers)
C23	5	5%
C45	10	10%
C22	15	15%
Total of above	30	30%
Total of other customers	70	70%
Total of all customers	100	100%

[v-cherch-msft · Accepted solution]

Hi @mengna 

You may use ALL Function like below:

Total of all customers =
CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )

Total of other customers =
CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
    - SUM ( 'Table'[Revenue] )

Regards,