AVG for Positive values and with the Positive Value's Row Count

Anonymous ,

You may modify your measure using DAX like below and check if it can meet your requirement:

Result =
CALCULATE (
    SUM ( 'Disk Space DW'[MB Change Value%] ),
    FILTER (
        'Disk Space DW',
        'Disk Space DW'[Computer Name] = EARLIER ( 'Disk Space DW'[Computer Name] )
            && 'Disk Space DW'[Disk] = EARLIER ( 'Disk Space DW'[Disk] )
            && 'Disk Space DW'[MB Change Value%] >= 0
    )
)
    / COUNTROWS (
        FILTER (
            'Disk Space DW',
            'Disk Space DW'[Computer Name] = EARLIER ( 'Disk Space DW'[Computer Name] )
                && 'Disk Space DW'[Disk] = EARLIER ( 'Disk Space DW'[Disk] )
                && 'Disk Space DW'[MB Change Value%] >= 0
        )
    )

Community Support Team _ Jimmy Tao

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