calculated row for matrix rows

Maggie,

Ffinally solved the problem as follows

Created three calculated columns which set a flag of 1

   if the Data is Data1 and Value >0 1, 0

   if the Data is Data2 and Value >0 1, 0

   if the Data is Data3 and Value >0 1, 0

Then created a measure which when used in a matrix visualiation adds up the flags.

Then set a filter to show only iitems where the measure of the sum is < 3 

This produces the desired matrix I gave as an example in the original question and only shows items where there is a missing required data value or one or more values is 0.

This is easily modified for any number of required data elements for a given row by adding more calculated flag columns and using them in the sum measure calculation then change the filter to 1 less than the total number of required data elements for each row.

Thanks for all the suggestions