Top Customers by billing per year

[Anonymous]

Good afternoon

I try to establish measures to know the top 5 customers per year, according to their turnover. That is, to carry out 3 measures for the years 2018, 2019 and 2020. In my calculated billing I have deleted customers whose Key is 1 and 3.

How could I do these measures?

I attach my customer billing measure to you.

Facturación Clientes = calculate([Total Facturación], filter(DimCliente, not(DimCliente[ClienteKey] in {1,3})))

I also attached customer billing 2020, which would be the same for the rest of years.

2020 Facturación Clientes = calculate([Total Facturación], filter(DimCliente, not(DimCliente[ClienteKey] in {1,3})),FILTER(DimCalendario,DimCalendario[Año]=2020))

[amitchandak · Accepted solution]

@Anonymous , Create a rank like this

rankx(allselected(DimCliente]) ,[Facturación Clientes])

Plot it in visual with year and client and put a visual level filter <= 5