Forum Discussion
SebSchoon1
Post Patron
Post PatronRankx Not working at all
Hi guys I have created a summarized Table with this formula Table = SUMMARIZE ( 'Tableau Dispatch', 'Base Article'[CODE ARTICLE], 'Base Artic...
Hi SebSchoon1 ,
Please try following DAX:
Rank = IF('Table'[taille] <> BLANK(),RANKX(FILTER('Table','Table'[taille] <> BLANK()),'Table'[taille],,ASC,Dense))The result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yadongf-msft
Community Support
Community SupportHi SebSchoon1 ,
Please try following DAX:
Rank = IF('Table'[taille] <> BLANK(),RANKX(FILTER('Table','Table'[taille] <> BLANK()),'Table'[taille],,ASC,Dense))
The result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.