How to write DAX about pareto for some value is same?

[luzwales]

I want to get Acc value

Item	Value	Acc Value
A	120	120
B	60	180
C	60	240
D	40	280
E	10	190

[Jihwan_Kim]

Hi, @luzwales 

Please check the below picture and the sample pbix file's link down below.

Acc value measure =
VAR rankbyitem =
RANKX ( ALL ( Data ), CALCULATE ( MAX ( Data[Item] ) ),, ASC )
VAR rankbyvalue =
RANKX ( ALL ( Data ), CALCULATE ( MAX ( Data[Value] ) ),, DESC )
VAR currentrankcombination =
RANKX ( ALL ( Data ), CALCULATE ( MAX ( Data[Item] ) ),, ASC )
+ 100 * RANKX ( ALL ( Data ), CALCULATE ( MAX ( Data[Value] ) ),, DESC )
VAR newtable =
FILTER (
SUMMARIZE (
ALL ( Data ),
Data[Item],
Data[Value],
"@rankbyitem", RANKX ( ALL ( Data ), CALCULATE ( MAX ( Data[Item] ) ),, ASC ),
"@rankbyvalue", RANKX ( ALL ( Data ), CALCULATE ( MAX ( Data[Value] ) ),, DESC )
),
[@rankbyitem] + 100 * [@rankbyvalue] <= currentrankcombination
)
RETURN
IF ( ISFILTERED ( Data[Item] ), SUMX ( newtable, Data[Value] ) )

https://www.dropbox.com/s/rc0rohk7fb880ww/luzwales.pbix?dl=0 

[daxer-almighty]

@luzwales, @Jihwan_Kim 

And here's why you should NEVER use SUMMARIZE for anything else but grouping:

All the secrets of SUMMARIZE - SQLBI

[luzwales]

It is very useful article for me! thanks!