Problem using Pareto: accumulated error on repeated values

Hi MaxViana 

I will use your sample in your new post to have a test, I think you are still confused in the same problem.

Firstly in build a NameRank in Ocorrenicas table.

NameRank = RANKX(Ocorrencias,Ocorrencias[Município Fato],,ASC,Dense)

Then Build new rank measure.

NameRanking = CALCULATE(MAX(Ocorrencias[NameRank]),ALLEXCEPT(Ocorrencias,Ocorrencias[Município Fato]))

NewRanking = 
RANKX(ALL(Ocorrencias[Município Fato]),[Ranking]+[NameRanking]/1000,,ASC,Dense)

Then you can calculate Acc and Acc%by your new rank.

For more details: How to use RANKX in DAX (Part 2 of 3 – Calculated Measures)

Best Regards,

Rico Zhou

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