Forum Discussion
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]...
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.
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.