Display rank by sum of total ignoring legend

[Anonymous]

Hello all,

I have 50 stacked bars (one for each state). I added "Product" to the Legend. Thus, each bar displays the sales grouped by product:

Example

I want to create a tooltip that displays the rank ordered by the total sales of each state. However, due to the legend, the tooltip returns three ranking positions per state: one rank for each product.

Is there a way to create a tooltip that sums by state and ignores the Legend?

Thanks in advance!

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

You could create a rank measure similar to below:

rank =
RANKX (
    ALLSELECTED ( Data_3 ),
    CALCULATE ( SUM ( Data_3[Value] ), ALLEXCEPT ( Data_3, Data_3[State] ) ),
    ,
    ASC,
    DENSE
)

Best regards,

Yuliana Gu