Can't get the total amount when filtering by TOPN

[MasterCamus]

Hi guys,

I'm using filters to filter the top 10 customers (first name) by [customer sale]. This is working fine. However, I'm trying to get the total of those top 10 so I can calculate %.

Total Sales =

CALCULATE(

[Customer Sale],

REMOVEFILTERS('Customer Lookup'[customer_first-name]

)

)

Customer Sale =

SUMX(

'Sales by Store',

'Sales by Store'[quantity_sold] * 'Sales by Store'[unit_price]

)

Example of what I'd want.

Allen = 1,741.50 / 17,950.59

Is this because of the filters?

Any tips?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your data model looks like,  but try to use ALLSELECT instead of using Removefilters.

[MasterCamus]

This worked. Thank you.

% Customer Sales by Group =

VAR _TotalCustomerSales =

CALCULATE(

[Customer Sale],

ALLSELECTED(

'Customer Lookup'[customer_first-name]

)

)

RETURN

DIVIDE(

[Customer Sale],

_TotalCustomerSales

)