Need help creating TopN and other(slicer)

[nikttk]

Hi,

I want to create a TopN rank and others(slicer), if selected top3 only top3 data should be show and effecting other visualizers too, also if i click focusing on the other visualize(ex.piechart - Android) the top3 should be recalculated to be top3 on Android user(still ranking by Country)

like the picture I've attached here :

I'm attracting the dummy data I've used to create here 

Data.xlsx

Thanks,

[v-lili6-msft]

hi @nikttk 

You could create a rank measure as below:

Rank = 
var _type= IF(RANKX(ALLSELECTED('Table'[Country]),[Top3Register],,DESC)<=3,"Top3","Other") 
var _table=FILTER(CROSSJOIN(SUMMARIZE('Table','Table'[Country],"_name",_type),'Type'),[_name]=[Name])  return
MAXX(_table,[_name])

Then use this rank measure instead of your [Register_rank]

Regards,

Lin

[nikttk]

Hi @v-lili6-msft

Thanks for the reply and guide, but may I ask where does [Name] come from ?

Thanks

[v-lili6-msft]

HI  @nikttk 

and here is my sample pbix file, please try it.

Regards,

Lin

[nikttk]

Hi @v-lili6-msft 

Thanks again for helping and sorry for my bad, btw according to your pbix file when selecting top3 the pie chart seem to still not affected by ranking, do you have any suggestion ?

Thanks

[v-lili6-msft]

hi  @nikttk 

That because you have very little sample data, you could add more sample data in the data model.

By the way, just adjust the measure [Top3Register] in the sample pbix file, use SUM instead of COUNTA.

Top3Register = CALCULATE(SUM('Table'[UserID]))

Regards,

Lin

[harshnathani]

Hi @nikttk ,

You can have a look at the below video.

https://www.youtube.com/watch?v=UAnylK9bm1I

Regards,

Harsh Nathani