top 5 and others but with Details

[Anonymous]

hello..

I made an equation to find top 5 and others to be displayed in Piechart by

1- create a table

Product Ranking = 
UNION ( 
    SELECTCOLUMNS (
        ALLNOBLANKROW ( 'Product'[Product Name] ),
        "Ranking name", 'Product'[Product Name],
        "Ranking group", 'Product'[Product Name]
    ),
    { 
        ( "Others", "Others" )
    }
)

2- create a measure

TopN Sales = 
IF (
    ISINSCOPE ( 'Product Ranking'[Ranking group] ),  -- Show a value only if the Ranking Group is filtered
    VAR NumOfProducts = 4
    VAR RankingGroup =
        SELECTEDVALUE ( 'Product Ranking'[Ranking group] )
    VAR TopProducts =
        TOPN ( NumOfProducts, ALLSELECTED ( 'Product Ranking' ), [Sales Amount] )
    RETURN
        if(
            RankingGroup <> "Others", 
                CALCULATE ( [Sales Amount], KEEPFILTERS ( TopProducts ) ),
                    if(
            RankingGroup = "Others", 
                IF (
                    NOT ISINSCOPE ( 'Product Ranking'[Ranking name] ),
                    VAR TopAmount =
                        CALCULATE ( [Sales Amount], TopProducts )
                    VAR AllAmount =
                        CALCULATE ( [Sales Amount], ALLSELECTED ( 'Product Ranking' ) )
                    VAR OthersAmt = AllAmount - TopAmount
                    RETURN
                        OthersAmt
                ))
        ),
    [Sales Amount]
)

3- the result was 

the next request was about when hover or drill down on others  it gives him the detaild Products in others

any help!

[lbendlin · Accepted solution]

Create a measure that uses CONCATENATEX of the product names. Use that measure as the tooltip.