The problem is that I have a top 10 measure with rankx:
Top Clientes =
Prod = [Mas Vendido]
Cliente = VALUES(Clientes[CompanyName])
RANKX(ALL(Clientes[CompanyName]); [Ventas Total];;DESC) <= 10); Productos[ProductName] = Prod)
And when I select an specific year it should only show me the top 10 customers who bought the top product, in this case Okkaba Skin Jackets, but if you see in the second image only 3 customers buy it that year, therefore in the table of the first image should only be 3 customers not 10, how can I fix this?
PSD: Here's the code for "Mas Vendido" if you need it:
Mas Vendido = FIRSTNONBLANK(TOPN(1; ALL(Productos[ProductName]);[Ventas Total];DESC); 1)
I checked another post as well where you have described the same/similar problem. Sorry but i cannot help much since the language there is no English. Also, the link that you have shared in your previous post does not work.
Thanks @Vvelarde but it doesn't work, because if I select 2013 it just give me 3 companies, when it should give me 6, in this order:
The idea is that the result should be the top 10 companies that have bought my "mas vendido" (top product). In this example the Halter Dress has had 0 sales along with other products, but in 2013 was the top buyed product from this group with almost 91K sales.