Removing values from a matrix if there are 0s or blanks

[Anonymous]

Hi there, 

I have a matrix with a number of attributes down the left and a number of columns checking how many nulls, too long and too short there are:

I need the matrix to not show the attributes in blue (they are all diffrent attributes) due to there being no values (0s or blank values) in column 2,3,4,6,7,8 (column 1 and 5 are irrelevant) and to only show the values under the red squares (there are values in one of 2,3,4,6,7,8)

In essence its looks to me like i need a nested IF( function like: 

IF( All records null = blank or 0 then IF( all records too long  blank or 0 then IF( all records too short = blank or 0 then IF( migrating records null = blank or 0 then IF(migrating records too short = blank or 0 then IF( migratin grecords too long = blank or 0  then dont show the attribute) IF ELSE( show the attribute,)

Something along those lines.

Any help would be much appreciate. 

TIA

[amitchandak]

@Anonymous , if all records are null, power bi should not show that, unless a measure is created to show that.

Also if there are multiple measures used then power bi can not remove the measure if all values are blank. You can try calculation groups for that

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[Anonymous]

Thank you @amitchandak 

So there will alwasy be atleast one populated column (either colum 1 ('All records'), column 5 ('migrating records') or both. Therefore poweri will alwasy show all the attributes. I would like to be able to create a measure that ignors those columns and if any of the other columns are blank or 0 then reome them from the table. 

i.e. only show those with a values in column 2,3,4,6,7,8 

thanks