Topn and others

[Anonymous]

     

1. For the above data i want to show topn and others.

2. I want to show the countries belonging to others like in the above image.

3. The above outputs i need, either i want to show top n and others(with countries belonging to others) or others(with countries belonging to others).

[pratyashasamal · Accepted solution]

Hi @Anonymous ,

You can create a calculated column

Top4 =

VAR __rank =  

RANKX(

    Sheet4,

    [user_amount],

    , ASC, Dense

)

RETURN

IF(

    __rank <= 4,

    [country],

    "other"

)
Then simply , create a hierarchy with Top 4 and country and add the Hierarchy and amount column in a matrix visual.
Or You can simply Add Top N and Country in Rows and amount in values for a matric visual without creating a hierarchy.

To create a hierarchy please follow this link :-
https://learn.microsoft.com/en-us/analysis-services/tabular-models/create-and-manage-hierarchies-ssa...

Thanks ,

Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C