Dax topN to percentage

[Anonymous]

im trying to convert  a set of values derrived from ranking to there equivilant percentage.

the schema is as follows 

Social Network CM Red Social	Users CM Red Social
(not set)	100
Academia	454
Buzzfeed	235
Facebook	676
Youtube	33
Instagram	67
Meetup	56
Twitter	345
(not set)	234
Academia	546
Buzzfeed	676
Facebook	87
Youtube	89
Instagram	76
Meetup	45
Twitter	78

i have one mesure that filters out a social network not needed and aggregates a total

Users CM Red Social Total = SUMX(FILTER('Grupo LD CM Red Social','Grupo LD CM Red Social'[Social Network CM Red Social] <> "(not set)"),'Grupo LD CM Red Social'[Users CM Red Social])

with this measure in hand i have another measure that ranks and gets the top 5 social media users

TopNRedSocial = if ( RANKX(all('Grupo LD CM Red Social'[Social Network CM Red Social]),CALCULATE([Users CM Red Social Total])) < 6,sum('Grupo LD CM Red Social'[Users CM Red Social]),BLANK())

how can i convert this to percentage knowing that the order and names can change dfrom day to day 

im thinking i can use the divide feature with a ranking to 5 and filter out the unwanted social media 

below is my current result i need that in percentage 

thanks 

[v-yuta-msft]

@Anonymous ,

You may modify the measaure as below:

TopNRedSocial =
IF (
    RANKX (
        ALL ( 'Grupo LD CM Red Social'[Social Network CM Red Social ] ),
        CALCULATE ( [Users CM Red Social Total] )
    ) < 6,
    SUM ( 'Grupo LD CM Red Social'[Users CM Red Social] )
        / CALCULATE (
            SUM ( 'Grupo LD CM Red Social'[Users CM Red Social] ),
            ALL ( 'Grupo LD CM Red Social' )
        ),
    BLANK ()
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

that gives me a percentage based on all the catagories including the ones not shown.

[Anonymous]

i changed the mesure to below 

TopNRedSocial =

IF (

RANKX (

ALL ( 'Grupo LD CM Red Social'[Social Network CM Red Social]),

CALCULATE ( [Users CM Red Social Total] )

) < 6,

SUM ( 'Grupo LD CM Red Social'[Users CM Red Social] )

/ CALCULATE (

SUMX (FILTER('Grupo LD CM Red Social','Grupo LD CM Red Social'[Social Network CM Red Social] <> "(not set)"), 'Grupo LD CM Red Social'[Users CM Red Social] ),

ALL ( 'Grupo LD CM Red Social' )

),

BLANK ()

)

its almost correct variance of 1 percent im guessing its tolarable

[Anonymous · Accepted solution]

fixed with the below

TopNRedSocial =

IF (

(RANKX (

ALL ( 'Grupo LD CM Red Social'[Social Network CM Red Social]),

CALCULATE ( [Users CM Red Social Total] ),6,DESC

) < 6),

'Grupo LD CM Red Social'[Users CM Red Social Total]

/ CALCULATE (

SUMX (FILTER('Grupo LD CM Red Social','Grupo LD CM Red Social'[Social Network CM Red Social] <> "(not set)"), 'Grupo LD CM Red Social'[Users CM Red Social] ),

ALL ( 'Grupo LD CM Red Social' )

),

BLANK()

)