Forum Discussion

Petsnell's avatar
Petsnell
Helper I
5 years ago

Filter zero from all rows except one

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...
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
Petsnell
Helper I
5 years ago

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's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Petsnell
      Helper I
      5 years ago

      Sample file.

       

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