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.

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" )

    )