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,

 

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.

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      8 years ago

      amilkarigi

       

      hi, Edit this measure:

       

      Mas Vendido =
CALCULATE (
    FIRSTNONBLANK ( TOPN ( 1; ALL ( Productos[ProductName] ); [ProdV]; DESC ); 1 );
    ALL ( Clientes[CompanyName] )
)

      Regards

       

      Victor

      Lima -Peru

      • amilkarigi's avatar
        amilkarigi
        Helper I
        8 years ago

        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:

        ResultExpected result

         

        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.