Forum Discussion

rmolinajr's avatar
rmolinajr
Frequent Visitor
8 years ago

Problem Rank Filter

Hi,

 

I have a date field that I use to filter, when I use a date filter along with the name field it gives problem.

 

 

That way it works, because I'm selecting all the dates, but when I select 2018 only.

 

 

 

When I select with Kevin, the correct ranking does not appear.

 

 

I tried putting a filtering on calculate with the dates, it still did not work, would you have any tips?

 

 

I am using this data:

 

NameValueDate
Roberto9020/05/2018
Maria3005/05/2018
Fatima2505/04/2018
Marcos7005/05/2018
Priscila12005/03/2018
Nicole1006/04/2018
Marcio7007/05/2018
Kevin2008/05/2018
Marta2009/02/2018
Fernando9010/05/2018
Roberto9020/05/2017
Maria3005/05/2017
Fatima2505/04/2017
Marcos7005/05/2017
Priscila12005/03/2017
Nicole1006/04/2017
Marcio7007/05/2017
Kevin2008/05/2017
Marta2009/02/2017
Fernando9010/05/2017

 

Need Help

3 Replies

  • anandav's avatar
    anandav
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    Hi rmolinajr,

     

    Try the measure:

     

    Measure Rank By =
        RANKX(
            ALL(Example),
            CALCULATE(
                SUM(Example[Value])
            ),,DESC,Dense
         )

     

    If it solves your problem please mark as solution.

    • rmolinajr's avatar
      rmolinajr
      Frequent Visitor
      8 years ago

      Hi anandav,

       

      I did the tests, but gave this problem!

       

       

      Could you tell me what the problem is?