NEED HELP WITH RANKING

[Anonymous]

here iam using this measure to calculate rank it is correct  but what if there is a missing weeknumber in the slicer then it returns 111 need to calculate previous week rank but if a weeknumber  is missing then it shows rank of one more priovous week need help to make  a rankmeasure as i mentioned thanks.

rankprevious week = 
 CALCULATE( RANKX(ALL('Table 3'[CompanyTitle]),[salepayment],,DESC,Dense),FILTER(ALL('tbl_Calendar_ph'),tbl_Calendar_ph[Week Rank]=MAX(tbl_Calendar_ph[Week Rank])-1))

[VahidDM]

HI @Anonymous 

You need to add a Date table to your report:https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

then add a relationship between Date table and your table. In the date table add your rank for weeks as a calculated column, and use this column in your slicer.

Share your PBIX file if it's possible

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/