Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rankx Breaking when field is being sorted?

Hello all.   I need to RankX my sales over Month/Year.   DAX is: Year/Month Rank (Master) = IF(HASONEVALUE('(SQL) Cart'[Related_Year_Month]),RANKX(ALL('(SQL) Cart'[Related_Year_Month]),[Master]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Based on my test, if you are using "ALL(tablename[column1])" in your formula, you can only sort by column1 and if you sort by other column, the rank result would all be 1.

If i use "ALL(table)", the result won't be affected by sort by column.

Thus, please try modifying your formula according to your table structure.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

unfortunley that doesnt work because the year month field is in transaCtion table and there are multiple values.

 

If I rank on a calendar table the rank wont update for filters.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Better to share your pbix to us if you don't have any Confidential Information. Otherwise it would be hard to find the problem. Please upload your files and share the link here.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

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