How to count positive and negative values of a measure

[AllyT11]

I have an 'On Target' measure that has been created from 3 separate tables - this is used on a matrix visual showing accounts/customers that are either on or below target.

Is there a way of doing a count of the accounts/customers that are on or exceeding their targets (all the positive values) and the same for negative values? Looking to show the % of accounts/customers that are on target vs those that aren't.

When I try adding a count measure the 'On Target' measure is not an option to select. Is this because already calculated measures cannot be used within another measure?

[tamerj1 · Accepted solution]

HI @AllyT11 
Please try

Count +ve =
COUNTROWS (
    FILTER (
        ADDCOLUMNS ( VALUES ( 'Table'[Customer Account] ), "@OnTarget", [On Target] ),
        [@OnTarget] > 0
    )
)

Count -ve =
COUNTROWS (
    FILTER (
        ADDCOLUMNS ( VALUES ( 'Table'[Customer Account] ), "@OnTarget", [On Target] ),
        [@OnTarget] < 0
    )
)