Forum Discussion

Petan65's avatar
Petan65
Frequent Visitor
2 years ago
Solved

RANKX always returns 1

Hello,   I went throught a lot of threads about this topic but any of the solutions hasn't work. I probably know why it's not working, but I don't know how to fix it. The reason is because all 3 cu...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Petan65 
    Try to do it with 2 measures : 

    1. total sales = sum('Table'[Sales])
    2. 
    Customer ranked by Sales =
    RANKX(
        ALL('Table'[Customer]),
        [total sales]
    )
    Unfortunately, I am out of the limit of images that I can attach to discussions.
    So I prepared a sample PBIX, you can download it from This link 
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
     
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Petan65 
    The card can't be filtered because it doesn't have a row context, unlike tables which are filtered by rows (categories), graphs which have this on axes, etc...
    What do you want from card to show? There is no card on the linked file...

Petan65's avatar
Petan65
Frequent Visitor
2 years ago

Sorry to bother you again. I thought that it all works as it should and in final step it stopped :/. Do you know why card visual does not show filtered value? Istead it shows total. Thank you
This link

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Petan65 
The card can't be filtered because it doesn't have a row context, unlike tables which are filtered by rows (categories), graphs which have this on axes, etc...
What do you want from card to show? There is no card on the linked file...

  • Petan65's avatar
    Petan65
    Frequent Visitor
    2 years ago

    Sorry in this file is the card. I need to show in card visual same result as have the table.

    this link  

    Edit: I've run into a second problem. When I would like to show the top 2 by month in the chart visual. It only works when I change X axis from date to "customer". Do you know how to make it work?
    thank you