March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello,
I need to calculate the % of top 1 over the total.
How can i craetea a measure?
Thank you,
Clara
Solved! Go to Solution.
Hi, thank you. I resolved with
Rank:
Offenders Rank_amt_ytd = RANKX(all('Top Offenders'[Employee Name]),[Offenders_SP_amt_YTD])
Hi, thank you. I resolved with
Rank:
Offenders Rank_amt_ytd = RANKX(all('Top Offenders'[Employee Name]),[Offenders_SP_amt_YTD])
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.
Hi @Anonymous
Would this help?
Measure = DIVIDE( MAX( 'Table'[Amt] ), SUM( 'Table'[Amt] ) )
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
User | Count |
---|---|
93 | |
90 | |
90 | |
81 | |
49 |
User | Count |
---|---|
160 | |
145 | |
103 | |
72 | |
55 |