Forum Discussion
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 was created to select all the data of the last 6th and 7th day. After that the rank measure was created and filtered the rank <=4. But some where it is going wrong ,because all the rank seems to be 1. how should I modify it. Could help?
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() ) )
3 Replies
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?
amitchandak ,it seems to work now. thanks a lot.
