Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
)
)
Thank you, this worked!
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
)
)
User | Count |
---|---|
50 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
63 | |
28 | |
18 | |
13 |