cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Top 1 % of the total

Hello,

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

How  can i craetea a measure?

Thank you,

Clara

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, thank you. I resolved with

Rank:

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

4 REPLIES 4
Anonymous
Not applicable

Hi, thank you. I resolved with

Rank:

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

Community Support

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.

Super User

Hi @Anonymous

Would this help?

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

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

``````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``````

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors