convert measure to column which i have to use in Pie chart

[Uzi2019]

Hi Experts,

I Have measure showing top 10 city n 11th as other value. I want to show in pie chart but not able to show because measure can not be added in "Legend" field of Pie chart. Please help me to solve this issue.I have created column but not showing correct result.

Actual answer should be this.I have taken measure because measure shows correct value.. but same formula is not working for calculated column. 

please help me to create correct column which shows above result.Thank you in Advance.

[Anonymous · Accepted solution]

Hi,

I think this will work for you:

legend = var a = RANKX(Facebook, CALCULATE(SUM(Facebook[Impressions]), ALLEXCEPT(Facebook, Facebook[Region])),,DESC,Dense)
return 
if(a >= 11 , "others", Facebook[Region])

Let me know if you need any help! 

[Uzi2019]

@Anonymous 

Thank you so much... It solved my issue...

[Uzi2019]

Hi,

For refrence i am attcahing link of Pbix file.

Want to display pie chart of top 10 city+ 11th as other values...

thank you in advance

https://drive.google.com/file/d/1nNSktMkDxrgLyyz0fZCnZwJxjOgyPrTw/view?usp=sharing