I'm not at all sure how you can total the
Risk Level column, so this is counting non-empty cells in that column when the
Product column is
exactly Secure or
Unsecure.
Code:
=SUM((February[Product]="Secured")+(February[Product]="Unsecured")*(TRIM(February[[Risk Level ]])<>""))
This one looks for
secure in the
Product column (which includes
Unsecure and
Secured LA) and non=empty cells in
Risk Level column:
Code:
=SUM(ISNUMBER(SEARCH("secure",February[Product]))*(TRIM(February[[Risk Level ]])<>""))
Still a bit of a guess as to what you want.