Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
    6 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

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 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
6 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