Forum Discussion
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 as to how I can apply these conditions on 'table.value <> something'?
4 Replies
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.
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.
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.
