Forum Discussion

amilkarigi's avatar
amilkarigi
Helper I
8 years ago
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];...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    amilkarigi

     

    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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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.