Hi Everyone,
I am trying to rank my order code data by the Avg. Qty Sold using the below DAX Formula. However when the I return the results I am seeing duplicate rank values (example below). Any suggestion on how to eliminate this issue?
Ranking = RANKX(
ALLSELECTED(detail),
CALCULATE(SUM(detail[avg_mth_qty_sold])),
,DESC,Skip
)
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - June 2024
Check out the June 2024 Power BI update to learn about new features.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
