Dynamic Axis and Top N - retain rank with legend

[Django46]

Hi Folks,

With this DAX i am able to get top n plans but whenever i want to include product inside these plans in legends, I am unable to use top N filter and also it is showing abrupt values 

TopN Plans =

VAR SelectedTop = SELECTEDVALUE('TopN'[TopN])

RETURN

SWITCH(TRUE(),

SelectedTop = 0,CALCULATE(SUM(viiv_agg_nbrx[nbrx])),

RANKX (

ALLSELECTED( viiv_agg_nbrx[plan name]),

CALCULATE(SUM(viiv_agg_nbrx[nbrx]))

)

<= SelectedTop,

CALCULATE(SUM(viiv_agg_nbrx[nbrx]))

)

I think this is related to DAX but i am not able to figure out, Tried crossjoin but with that also didn't got relevant result 

[sturlaws]

Hi again, @Django46,

could try to create a measure like this:

topNPlans =
VAR _plan =
    CALCULATE ( SELECTEDVALUE ( Sales[Plan] ) )
RETURN
    CALCULATE (
        COUNTROWS (
            FILTER (
                FILTER (
                    ADDCOLUMNS (
                        VALUES ( Sales[Plan] );
                        "rank"; RANKX ( ALL ( Sales[Plan] ); CALCULATE ( SUM ( Sales[Sales] ) ) )
                    );
                    [rank] <= 2
                );
                Sales[Plan] = _plan
            )
        );
        ALL ( Sales[Product] )
    )

and then use this measure as filter for you visual, topNPlans>=1:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[Django46]

It is not helping 

[sturlaws]

I would like to help you with your problem. Could you please share your report, or create and share a sample report?