Forum Discussion
RANKX not working
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() ) )
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() ) )
amitchandak I have another issue which I face now. As I had mentioned earlier , I need to get the 4 higest of the 7th and 6th day which I am able to get. But the 6th day data displayed today and tmw(tmw -then it becomes the 7th day) the time changes because the 4 highest data collected changes. How can I make it the same ? Pls ref to the below pictures.
If you see the wednesday data , it is different in the two tables. So how do I select individually for each day and combine so that It does not change?
