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.

Highlighted
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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 27 members 920 guests
Please welcome our newest community members: