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

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

    Thanks a lot Vvelarde, you really helped me. I've been working on that problem for a week and now I finally finished :robotvery-happy:

  • 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: