Calculate top 5 and other

[Zana]

I am trying to select the top 5 states and other graphs

my dataset is 1000 startups 

these startups were founded in different states of course. I want to show them like 

state perc

CA    25

NY   20

Al    15

FL    12

Others 28

what should I do

[Padycosmos]

This video would help:

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

[Tahreem24]

  Try this measre:Top5 =
VAR _top5 =
    TOPN (
        5,
        ALLSELECTED ( TableName[State] ),
        CALCULATE ( SUM ( TableName[Perc] ) ), DESC
    )
VAR CurrState =
    SELECTEDVALUE ( TableName[State] )
VAR result =
    IF ( CurrState IN top5, CurrState, "Others" )
RETURN
    result

@Zana

[Zana]

Thank you @Tahreem24 

So I need first to build a perc field. 

Do you have any suggestions?

I have overview[state] field, it is better to build a new column as states[percentage], states table also has [state] filed for relation.

I should count all states themselves and divide by the total which is obviously 1000. But  I couldn't do this too.

Edit: Sorry It wasn't difficult, I made it 

[Tahreem24]

@Zana For a Perc you need to create a measure like below:

Perc = 
VAR _statewise = CALCULATE(COUNT(TableName[State]))
VAR _total = CALCULATE(COUNT(TableName[State]),ALL(TableName))
RETURN DIVIDE(_statewise,_total,0)

Then follow my previous post formula to get the Top 5 and others.

[Zana]

is there any mistake on this row:

IF ( CurrState IN top5, CurrState, "Others" )

when I add _ in front of the top5 it works, like : 

IF ( CurrState IN _top5, CurrState, "Others" )

on the other hand, I made this but how should I see the results of this function? I didn't understand how can I use it. 

[amitchandak]

@Zana , refer my approach on the same

Power BI- Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE

[Zana]

I give up on solving problems in these ways. I need more simple and sustainable solutions. Thanks for your helps.