Forum Discussion

nicolas23498324's avatar
nicolas23498324
Frequent Visitor
5 years ago
Solved

Creating Ranking by Week Measure on top of Virtual Tables

Hello,   My dashboard tracks volume collections daily. I've been able to use RANKX to create a daily ranking measure without an issue. What I would like to do now is give the current selected week ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi nicolas23498324 ,

     

    You could create a weeknum column.

    Please check the formulas below.

     

    weeknum = WEEKNUM('Table'[date],1)

Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[weeknum]))

Measure 2 = RANKX(ALLSELECTED('Table'[weeknum]),[Measure],,DESC,Dense)

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi nicolas23498324 ,

 

You could create a weeknum column.

Please check the formulas below.

 

weeknum = WEEKNUM('Table'[date],1)

Measure = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[weeknum]))

Measure 2 = RANKX(ALLSELECTED('Table'[weeknum]),[Measure],,DESC,Dense)

 

 

Best Regards,

Jay