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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
EitanKGCS
Frequent Visitor

RANKX skipping and duplicating ranks with different figures when using a filter slicer

Hey everyone,

 

I have a top 10 rank matrix for a few different categories on a dataset. 

 

For some reason, when I try to use a filter slicer to show different results it starts duplicating ranks or skipping numbers out.

 

EitanKGCS_0-1661941032386.png

 

RankSpecialism = IF(
NOT(
ISBLANK([total GP])),
RANKX(
Filter(
ALLSELECTED('All Companies'[Specialism]),[Total GP]),
[Total GP],,
DESC
,Dense))

 

I have tried changing the ALL to ALLSELECTED and a few different versions. does anyone have any advice on what I could try to get this working correctly even if I filter using a filter slicer?

 

Thanks in advance!

4 REPLIES 4
Fowmy
Super User
Super User

@EitanKGCS 

Please try the following :

RankSpecialism =
IF (
    NOT ( ISBLANK ( [total GP] ) ),
    RANKX ( ALLSELECTED ( 'All Companies'[Specialism] ), [Total GP],, DESC, DENSE )
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Still no luck!

 

EitanKGCS_0-1661941877291.png

Still getting this result when filtering using a slicer.

 

@EitanKGCS 

Please share your [Total GP] Measure.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Total GP = SUMX('All Companies',[@Profit])

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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