RANKX not working

[Learner_SG]

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]

@amitchandak ,it seems to work now. thanks a lot.

[amitchandak · Accepted solution]

@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]

@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?