Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with pareto

Hi Power BI Community! I count on your expertise.

 You can see that the pareto line is wrong.
I use this measure:

pareto SAP = var total = calculate(COUNT('Stammdaten (3)'[ID]); ALLSELECTED('Stammdaten (3)'))
var currentnumber = count('Stammdaten (3)'[ID])
var summarizetable= SUMMARIZE(ALLSELECTED('Stammdaten (3)');'Stammdaten (3)'[SAPPartNumber]; "Revenue"; COUNT('Stammdaten (3)'[ID]))
var cumulativesum = SUMX(filter(summarizetable; currentnumber <=[Revenue]);[revenue])
return cumulativesum/total*100

I use this exact measure by another pareto chart and it looks fine. What can I do?

Thank you for your time.

  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Currently we  can only judge that the [PARATO SAP] value of these three rows of data does not exist.
    Without the original data , it is difficult to figure out the specific reason.
    What should the result in  three rows look like? If possible,please upload a sample pbix file to OneDrive for testing .
     
    Best Regards,
    Community Support Team _ Eason

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Here you go. Its not the real data. 

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Anonymous ,

         

        It's hard to understand that why you say the chart is wrong?

         

        Based on your sample data screenshot, the chart looks right to me.

         

        Please elaborate if I am missing anything here.

         

        Thanks,

        Pragati

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi , Anonymous 

    Could you please tell me whether your problem has been solved?
    If yes, you could share your own solution here.

    For now, there is no content of description in the thread.

     

    Best Regards,
    Community Support Team _ Eason