Forum Discussion

MaxViana's avatar
MaxViana
Frequent Visitor
5 years ago

Problem using Pareto: accumulated error on repeated values

Hello friends! I need to create a Pareto chart and I'm finding it difficult to create a metric that shows me the cumulative total for each row ordered by a ranking. I can create the ranking...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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. 

  • MaxViana's avatar
    MaxViana
    Frequent Visitor
    5 years ago

    Realize that the problem persists. In the 13th and 14th rank, the cumulative measures still do not work.