Forum Discussion

Learner_SG's avatar
Learner_SG
Helper IV
4 years ago
Solved

RANKX not working

Hi All, Could anyone help on this error. My RankX function is not working as expected. I need to select the top4 of the last 7th and 6th day data. These are the steps that  I have done. A measure w...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Learner_SG , In Rankx you should columns, that will be present in visual or you should use table having both

    Rankx( All(Table[Time], Table[WeekDay]), [Measure],,desc,dense)

     

    Measure should have calculation and filter

     

    measure = calculate(sum(Table[Value]), filter(Table, Table[Date]>= Today() -6 && Table[Date]<=Today() ) )