The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
38 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
40 | |
29 | |
24 | |
23 |