cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rmolinajr Frequent Visitor
Frequent Visitor

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.

010.PNG

 

 

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

020.PNG

 

 

 

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

030.PNG

 

 

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

 

3 REPLIES 3
anandav Established Member
Established Member

Re: Problem Rank Filter

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 Frequent Visitor
Frequent Visitor

Re: Problem Rank Filter

Hi @anandav,

 

I did the tests, but gave this problem!

Capturar.PNG

 

 

Could you tell me what the problem is?

 

 

 

 

ChandeepChhabra Established Member
Established Member

Re: Problem Rank Filter

@rmolinajr Can you share how the expected output should look like ?

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors