Forum Discussion

bullius's avatar
bullius
Helper V
9 years ago
Solved

Percentages do not equal 100%

Hi

 

I have produced a mathematically impossible pie chart:

 

Including the segments that do not have a data label, the total % = 101.72%

 

The data behind it is confidential, so I can't share it, but the amounts were produced by perfoming a distinct count of a values in one table with legend fields from another table.

 

Does anyone know any circumstances that might lead to this happening?

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Yep, that can happen:

     

    Name, Awesomeness

    Scott, Very

    Avi, Very

    Tom, Not Very

    Scott, Not Very

     

    The Count := DISTINCTCOUNT(MyTable[Name])

     

    Slice this by Awesomeness...

    2 Very Awesome (Scott, Avi)

    2 Not Very Awesome (Scott, Tom)
    3 Total (Scott, Tom, Avi)

     

    4/3 = 133%

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Yep, that can happen:

     

    Name, Awesomeness

    Scott, Very

    Avi, Very

    Tom, Not Very

    Scott, Not Very

     

    The Count := DISTINCTCOUNT(MyTable[Name])

     

    Slice this by Awesomeness...

    2 Very Awesome (Scott, Avi)

    2 Not Very Awesome (Scott, Tom)
    3 Total (Scott, Tom, Avi)

     

    4/3 = 133%

     

    • bullius's avatar
      bullius
      Helper V
      9 years ago

      Thanks Anonymous,

       

      So, how do I get it to count "Scott" for both [Awsomeness] values, so that it totals 100%?

       

      I have tried using COUNT instead of DISTINCTCOUNT and it returns the same reults.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I guess you would have to better explain what you want to see.

         

        Say I had a chart of cars, and wanted to show Red, Blue and Green cars.   Since some cars come in multiple colors... 

         

        Red:  { Toyota, Honda }

        Blue:  { Toyota, Ford, Honda }

        Green: { Honda }

         

        2 (distinct) cars come in red, 3 in blue, and 1 in green.  There are 3 total distinct cars.

         

        It is correct to say 66% of cars come in red, 100% in blue, and 33% in green.   The "grand total" would be 200%, but that is a meanless #... that I really wouldn't worry about.