Visual interaction problem

[erihsehc]

for the above 2 tables connected with "Customer", the sales amount sumif from the first table.

sales = CALCULATE(SUM(Table1[sales]),Table1[Customer]=EARLIER(customer[Customer]))

how to rank the customer by sales in the second table that when I select different factory in first table, the ranking will be updated in the second table presented in the visual? thanks

[v-jiascu-msft · Accepted solution]

Hi @erihsehc,

If you want to select factory dynamically, you have to use a measure and a report.

Ranking =
RANKX ( ALL ( 'Table1'[Customer] ), CALCULATE ( SUM ( 'Table1'[Sales] ) ) )

Best Regards!

Dale