How can I show top 10 and bottom 10 values in one visual ?

[Anonymous]

I am having one table from there I want to fetch top 10 customer and bottom 10 customer in one visual. 

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below. (top3 and bottom3 show up together).

Please check the picture and the attached pbix file.

I hope the below sample can provide some ideas on how to create a solution for your datamodel.

Sales measure: = 
SUM( Data[Sales] )

top three and bottom three measure: =
VAR _topthreelist =
    SUMMARIZE (
        TOPN ( 3, ALL ( Data[Customer] ), [Sales measure:], DESC ),
        Data[Customer]
    )
VAR _bottomthreelist =
    SUMMARIZE (
        TOPN ( 3, ALL ( Data[Customer] ), [Sales measure:], ASC ),
        Data[Customer]
    )
VAR _unionlist =
    UNION ( _topthreelist, _bottomthreelist )
RETURN
    CALCULATE ( [Sales measure:], KEEPFILTERS ( _unionlist ) )

[Anonymous]

Thank You.