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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.