Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RANKX issue

Hi all,   Got an issue with RANKX. Here is my data model :   1 Fact table : Sales 2 dimensions tables : Calendar, stores   I want to create a measure to have store's rank over turnover.   I...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    You can use the following  measure in your table visual:

     

    Rang CA BU Mois Filtre = var a = SUMMARIZE(ALL(Stores),Stores[Magasin],"CA TTC",[CA TTC Mois],"rank",RANKX(ALL(Stores),CALCULATE([CA TTC Mois],ALLEXCEPT(Stores,Stores[Magasin])),,DESC)) return SUMX(FILTER(a,Stores[Magasin] = MAX(Stores[Magasin])),[rank])

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I modified my pbix, so i can send it. (70Mo)

How can i send it to you ?

You could give me your @ by private message ?

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Would you please try to use the following rankx measure for it:

RANKX = RANKX(ALL('Stores'[magasin]),CALCULATE(SUM('Daily Sales N'[MNT_TTC])),,DESC)

If it dosen't work, would you please try to show us some sample data just contain these three table by onedrive for business?

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    My problem is still here.

    Here are samples of data :

     

    My joins are :

    (1) STORES.RK_ETT = SALES.FK_ETT (n)

    (1) CALENDAR.DAT_REF = SALES.DAT_VTE (n)

     

    If you want the pbix, can you give me your @, so i can give you access to my drive

     

    Regards,

    Julien