Count IF

Hi, Anonymous 

You can try the following methods.

Table:

Average =
SUMMARIZE (
    'Table',
    'Table'[Item],
    "Average",
        CALCULATE (
            AVERAGE ( 'Table'[%] ),
            FILTER ( ALL ( 'Table' ), [Item] = EARLIER ( 'Table'[Item] ) )
        )
)

Column:

Ball collour =
IF (
    [Average] < 0.9,
    "Yellow ball",
    IF ( [Average] > 1.1, "Red ball", "Green ball" )
)

Measure:

Count =
CALCULATE (
    COUNT ( 'Average'[Item] ),
    FILTER ( ALL ( 'Average' ), [Ball collour] <> "Green ball" )
)

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

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

Hello Again:

Since there is one yellow ball I made % both including Yellow and not including yellow. Please see file link.https://drive.google.com/file/d/1fw1_03W0Pn_eOG8CdKhOvSiwVrcXrGru/view?usp=sharing