Forum Discussion

DannyPhillips's avatar
DannyPhillips
Regular Visitor
7 years ago
Solved

Graphing Calculated Sums

I have data that essentially looks like this:   Company_Label Product_Label COUNT John's Apples Red Delicious 1 John's Apples Honeycrisp 1 Industry Total Red Delicious 1 Indu...
  • dax's avatar
    dax
    7 years ago

    Hi,

     

    You could try below measure

    Measure =
IF (
    MIN ( t1[Company_Label] ) = "John's Apples",
    CALCULATE ( COUNT ( t1[Company_Label] ), t1[Company_Label] = "John's Apples" ),
    COUNT ( t1[Company_Label] )
        - CALCULATE ( COUNT ( t1[Company_Label] ), t1[Company_Label] = "John's Apples" )
)

    Best Regards,

    Zoe Zhi

     

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

dax's avatar
dax
Community Support
7 years ago

Hi DannyPhillips,

 

In your scenario, you said you want to get John's Apples vs. Everyone Else (2 of 6), what did you mean of “everyone”? Did you want to get John's Apples vs. Industry Total(2:6)? If so, you could just create measure Measure 3 = COUNT(sharechart[Product_Label]), it will return result like below

If this is not what you want, could you please inform me in details(such as your expecting output and your detailed sample data)? Then I will help you more correctly.

 

Best Regards,

Zoe Zhi

 

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

DannyPhillips's avatar
DannyPhillips
Regular Visitor
7 years ago

Thanks for the response, the issue is that your example table shows a grand total of 8, but the industry total is already the grand total.  What I really would like is to be able to chart the results like this:

 

but I don't have a "competitor" company label, I just know it is the sum of industry total minus the sum of John's Apples. I would also like a simple table like this:

 

but I'm unsure of how to create that.

  • dax's avatar
    dax
    Community Support
    7 years ago

    Hi,

     

    You could try below measure

    Measure =
IF (
    MIN ( t1[Company_Label] ) = "John's Apples",
    CALCULATE ( COUNT ( t1[Company_Label] ), t1[Company_Label] = "John's Apples" ),
    COUNT ( t1[Company_Label] )
        - CALCULATE ( COUNT ( t1[Company_Label] ), t1[Company_Label] = "John's Apples" )
)

    Best Regards,

    Zoe Zhi

     

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

    • DannyPhillips's avatar
      DannyPhillips
      Regular Visitor
      6 years ago

      Thank you so much for the solution!  I changed it to the below to accomodate if the count was ever more than 1. This appears to be working.

       

      Measure =

      IF (

          MIN ( t1[Company_Label] ) = "John's Apples",

          CALCULATE ( SUM ( t1[COUNT] ), t1[Company_Label] = "John's Apples" ),

          SUM ( t1[COUNT] )

              - CALCULATE ( SUM ( t1[COUNT] ), t1[Company_Label] = "John's Apples" )

      )