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]); ALL...
  • 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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      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

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      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