Filter zero from all rows except one

[Petsnell]

The measure below is a filter to remove all zero values in my matrix, but since I am using the Financial Reporting Matrix by Profitbase I need to remove one row value from the filter. Any suggestions as to how I can apply these conditions on 'table.value <> something'?

Remove zeros = IF(AND(AND([Measure 1]=0,[Measure 2]=0),AND([Measure 3]=0,[Measure 4]=0)),0,1)

[amitchandak]

@Petsnell you can use <>

example

IF([Measure 1]=0 && [Measure 2]=0 && [Measure 3]=0 && [Measure 4]<> 0,0,1)

also you can use && in place of AND(

IF([Measure 1]=0 && [Measure 2]=0 && [Measure 3]=0 && [Measure 4]=0,0,1)

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Petsnell]

@amitchandak Thank you for answering so quickly. Please apologize my terrible example below, I will add on this if necessary. 

In short, I want to remove row values that equal zero in the measures listed above except for the second last row in the picture, let's call it 'table.example' with value = F. 

[amitchandak]

@Petsnell , removing a row while creating a measure(means table row) is much different from removing a row(visual table) where a measure is 0 or blank. 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Petsnell]

Sample file.

In short, I want to see R&D, but hide operations and other rows where all columns might be 0.