Top 1 % of the total

[Anonymous]

Hello,

I need to calculate the % of top 1 over the total. 

How  can i craetea a measure?

Thank you,

Clara

[Anonymous · Accepted solution]

Hi, thank you. I resolved with

Rank:

Offenders Rank_amt_ytd = RANKX(all('Top Offenders'[Employee Name]),[Offenders_SP_amt_YTD])

[v-junyant-msft]

Hi @Anonymous ,

The test data sheet name is 'Table':

You can use the following DAX to create a measure:

%_Top1_Total = 
VAR TotalSum = SUMX('Table','Table'[data])
VAR Top1 = MAX('Table'[data])
RETURN
DIVIDE(Top1, TotalSum) * 100

And the final output is shown in the following figure:

Best Regards,

Dino Tao

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

[gmsamborn]

Hi @Anonymous 

Would this help?

Measure = DIVIDE( MAX( 'Table'[Amt] ), SUM( 'Table'[Amt] ) )

[Dangar332]

hi, @Anonymous 

@Anonymous 

try below

Measure = 
SUM('Table (2)'[Column2])/SUMX(ALL('Table (2)'),'Table (2)'[Column2])

see below image

change basic filter to TOPN

or you can use below measure also
just adjust your table and column name

Measure 2 = 
var a = CALCULATE(SUM('Table (2)'[Column2]),ALL('Table (2)'))
var b =CALCULATE(max('Table (2)'[Column2]),ALL('Table (2)'))
var c = 
   CALCULATE(
       DIVIDE(
         SUM('Table (2)'[Column2]),
         a
       ),
       FILTER('Table (2)','Table (2)'[Column2]=b)
    )
return c