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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
trishd1223
Frequent Visitor

Rankx starting at 3 instead of 1

Hi, I'm trying to rank a measure in Power BI and for some reason it's starting at 3 instead of 1.  Here is my sample data.  Formula is below.  This formula worked when I used it for $ Sales, but it's not working on $/TDP. 

 

Rank $/TDP THP Items =
   IF (
    [$ / TDP] <> 0,
    RANKX (
        FILTER (
            ALL(AppendedData[THP Item Mapping.Aggregate] ),
            [$ / TDP] <> 0
        ),
        [$ / TDP]))

 

Thanks.  rankx.jpg

1 ACCEPTED SOLUTION
nirali_arora
Resolver II
Resolver II

Try this

Rank $/TDP THP Items =

IF (

[$ / TDP] <> 0,

RANKX ( ALLSELECTED(AppendedData[THP Item Mapping.Aggregate]), -- Use ALLSELECTED instead of FILTER and ALL

[$ / TDP],

,

ASC, -- Rank in ascending order

Dense -- Handle ties by assigning the same rank

)

)

View solution in original post

2 REPLIES 2
trishd1223
Frequent Visitor

Thank you, this worked!

nirali_arora
Resolver II
Resolver II

Try this

Rank $/TDP THP Items =

IF (

[$ / TDP] <> 0,

RANKX ( ALLSELECTED(AppendedData[THP Item Mapping.Aggregate]), -- Use ALLSELECTED instead of FILTER and ALL

[$ / TDP],

,

ASC, -- Rank in ascending order

Dense -- Handle ties by assigning the same rank

)

)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors