TopN and sum of rest in a 100% stacked bar chart

[Claus_Vad]

Hi all

Can anyone help with a measure calculating TopN and sum of rest,to be shown in a 100% stacked bar chart

I've tried following example sqlbi.com

Product Ranking =

UNION (

SELECTCOLUMNS (

ALLNOBLANKROW ( 'financials'[Product] ),

"Ranking name", 'financials'[Product],

"Ranking group", "Best Products"

),

{ ( "Other", "Other" ) }

)

TopN Sales =

IF (

ISINSCOPE ( 'Product Ranking'[Ranking group] ),

VAR NumOfProducts = 3

VAR RankingGroup =

SELECTEDVALUE ( 'Product Ranking'[Ranking group] )

VAR TopProducts =

TOPN ( NumOfProducts, ALLSELECTED ( 'Product Ranking' ), [Sales Amount] )

RETURN

SWITCH (

RankingGroup,

"Best Products",

CALCULATE ( [Sales Amount], KEEPFILTERS ( TopProducts ) ),

"Other",

IF (

NOT ISINSCOPE ( 'Product Ranking'[Ranking Name] ),

VAR TopAmount =

CALCULATE ( [Sales Amount], TopProducts )

VAR AllAmount =

CALCULATE ( [Sales Amount], ALLSELECTED ( 'Product Ranking' ) )

VAR OtherAmt = AllAmount - TopAmount

RETURN

OtherAmt

)

),

[Sales Amount]

)

But the result is not what I want, the TopN Sales show the left Bar Chart, I want it like the right Bar Chart.

 Thanks in advance, Claus

[johnt75]

Try using Ranking Name rather than Ranking Group in the column chart.