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

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.

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    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

    • amilkarigi's avatar
      amilkarigi
      Helper I
      8 years ago

       

      Could you please send me that pbix file, because in mine it still shows the same and I still don't know why it persists in showing me companies it shouldn't: