Dynamic TOP Customers/Others Column

[Anonymous]

I want to make a calculated column for "TOP" and "Other" Customers. I use the column "Cust Rank" for the separation. 

It works fine except that it should be applied to the top customers of the current year. In the example below top customers from last year should be "Rest". 

I guess it comes down to the question how I can change the DAX below so that column" Cust Rank" is filtered by the selected year. (In this case 2018) 

Thanks for any kind of suggestions. 

Matt

PS: The Column "Cust Rank" ranks the Customers in every year based on total Sales. 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

The returned result by a calculated column is static once it is initialized. In your scenario, to get dynamical Cus_rank and Top/Other Customers based on slicer selections is not possible.

Regards,

Yuliana Gu

[Anonymous]

Ok, thx. Any ideas how to solve this though?

I guess I could change the measures to get the expected results. I thought it might be possible with the calculated column..

Anyway thx for the reply..

Matt