Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Average not being calculated correctly

Hi,

 

I have created a table and only the average of one group is not being calculated correctly. I am unable to identify the issue. Below is the table the average for Employed and Social Welfare is incorrect. However, min and max are correct and average for other income groups are correct.

When I don't summarize it the values are coming correctly only as below:

The average should be 470 as per this: total/3. Only with average there is an issue.

 

Anyone has a clue?

 

Thanks in advance!

 

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      vanessafvg I an not using any calculation. I am just using value as average as below:

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    It does work on my side.

     

    How about using the AVERAGE() like this:

    Measure = CALCULATE(AVERAGE('Table'[Weekly Income]),ALLEXCEPT('Table','Table'[Income Group]))

    If it does not make sense, please share me with your pbix file after removing sensitive data so that I could have a try again.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed, so that more people will benefit from it.

     

    Thanks in advance!

     

    Best Regards,
    Eyelyn Qin