Forum Discussion
Petsnell
Helper I
Helper IFilter 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...
PetsnellHelper I
Helper Iamitchandak 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
Super User
Super UserPetsnell , 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
In short, I want to see R&D, but hide operations and other rows where all columns might be 0.