RANKX Always Returns 1

v-huizhn-msftand Sean

Basically I need a dynamic top 5 filter by quantity of product defects for my stacked column chart.

I've created a simplified data set called MyData including rows of claim ID, Name, ProductLine, Product, Category, Region, Date, Quantity, and Cost.  I made ProductLine and Category slicers and a stacked column chart with Product on the axis, Date in the legend, and Cost as the value then I sort by Cost.  Quantity allows for multiple defective Products on one claim (data set of 100 claims with 124 total quantity).  All of this works nicely.

Now I add the following Measure for total quantity:

TotalQuantity = CALCULATE(SUM(MyData[Quantity]), ALLEXCEPT(MyData, MyData[ProductLine], MyData[Category]))

I added a card for TotalQuantity which updates correctly when I toggle the slicer options.

For rank, first I tried the following Column in attempt to get a 1-N rank of my Products so that later I can simplify my stacked column chart to top X:

QuantityRankColumn = RANKX(ALL(MyData[Product]), [TotalQuantity], , DESC)

Then I added a column chart for QuantityRankColumn by Product and this results in the count of claims (rows) for each Product, summing to 100 (total number of rows).

I thought it was odd doing ALL(MyData[Product]) by not including Quantity so I changed it to ALL(MyData[Product], MyData[Quantity]) but that didn't change anything.

Next, I tried the following rank Measure to see if I had better luck here than with my above rank Column:

QuantityRankMeasure = IF(HASONEVALUE(MyData[Product]), RANKX(ALL(MyData[Product]), CALCULATE(SUM(MyData[Quantity]), ALLEXCEPT(MyData, MyData[ProductLine], MyData[Category]))))

This results in a rank of 1 for all Products.  I also tried removing the IF statement then including the Quantity column in the ALL function but again no change away from all 1's.

I've used other visualization tools and this method for Power BI seems like a lot of overcomplicated work to simply see only the top bars in a chart.  I'm open to suggestions.