Forum Discussion
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...
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
Hi Anonymous ,
Would you please show us sample pbix by onedrive for business?
Best Regards,
Dedmon Dai
Can you try this link :
Pass : RankX_Issue
Regards,
Julien
Hi Anonymous ,
Please check the permission for it.
Best Regards,
Dedmon Dai
Please try this one :
Password : RankX_Issue
Regards,
Julien
Hi Anonymous ,
Is the screenshot below you want?
Please refer to the measure:
Rang CA BU Mois Filtre = if(HASONEVALUE(Stores[Magasin]),rankx(all(Stores[Magasin]),[CA TTC Mois],,DESC),0)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