Forum Discussion
Solved
RANKX Measure issue
The problem is that I have a top 10 measure with rankx: Top Clientes =
VAR
Prod = [Mas Vendido]
VAR
Cliente = VALUES(Clientes[CompanyName])
RETURN
CALCULATE([Ventas Total];...
HI, I try to simplify this:
Top Clientesrl = VAR Prod = [Mas Vendido] RETURN CALCULATE ( [Ventas Total]; Ordenes[ProductName] = Prod )in the visual level filter
regards
Victor
Hi,
My suggestion is to create a seperate RANK measure
=RANKX(ALL(Clientes[CompanyName]); [Ventas Total];;DESC)
Now in the first visual, drag this measure to the Visual Level filters and apply a criteria there of <=10.
It's does nothing :smileysad: here's a link where you can download the pbix document for better comprehension https://drive.google.com/open?id=1CHv9ejaaboVk7kS-7V0W61GPzb8uS7qs
Hi,
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.
hi, Edit this measure:
Mas Vendido = CALCULATE ( FIRSTNONBLANK ( TOPN ( 1; ALL ( Productos[ProductName] ); [ProdV]; DESC ); 1 ); ALL ( Clientes[CompanyName] ) )Regards
Victor
Lima -Peru