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 think your problem is that when your Atual is repeated, you will get the wrong acc.

Ex: Toc... Atual = 9, Acc should be 225+9 = 234 instead of 243.

     Tag... Atual = 9, Acc should be 234+9 = 243.

Is it right?

I think you can achieve your goal by build a ranking column(not a measure) which is not repeated.

Try this measure:

Acc = SUMX(FILTER(ALL('Ocorrencias'),'Ocorrencias'[Rank]<=MAX('Ocorrencias'[Rank])),'Ocorrencias'[Total])

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business.

 

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

    I was not able to do that, my friend RicoZhou. đŸ˜­
    I don't know how to create a ranking in a column.

    I've been struggling with this for a while. I'm almost giving up on making this Pareto.

    Would you help me with it?
    Sample:
    https://1drv.ms/u/s!AoIveuLXWhhKgvBs0Sp-a2NhLHAwSg?e=KFgAEF


    • 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.