Problem with pareto

[Anonymous]

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]

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

[vanessafvg]

are you able to provide some dummy data?

[Anonymous]

Here you go. Its not the real data. 

[Pragati11]

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

[Anonymous]

My problem is why is there no data in the first rows? 
Why does the pareto line starts in the middle and not at the beginning of the chart?

Thanks for your reply

[v-easonf-msft · Accepted solution]

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

[Pragati11]

Hi @Anonymous ,

First thing try to tag the person whom you are replying to.

In order to understand why there is no data for top 3 rows, you will have to check your raw data.

Try sharing the raw data here if possible.

Thanks,

Pragati