cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Display rank by sum of total ignoring legend

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:

Capture.PNGExample

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Display rank by sum of total ignoring legend

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
)

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Display rank by sum of total ignoring legend

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
)

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.