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...
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.
In short, I want to see R&D, but hide operations and other rows where all columns might be 0.