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,

 

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

)