Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rmolinajr
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
ChandeepChhabra
Impactful Individual
Impactful Individual

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

anandav
Skilled Sharer
Skilled Sharer

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.

Hi @anandav,

 

I did the tests, but gave this problem!

Capturar.PNG

 

 

Could you tell me what the problem is?

 

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.