Forum Discussion
Filter matrix based on single value
Thanks ahead of time for the help. I would like to filter out any employee if ALL entries are "-GOOD-". However, if even one entry is not "-GOOD-", he/she should not be filtered. The matrix...
Remember that measures are calculated for every element of your visual separately. For a matrix visual that means four different calculations: cell, row totals, column totals, and grand total. In your case you need to write a measure that calculates the row total based on all the column values for that row. That means you need to use an aggregator function.
if you want more guidance please post sample data in usable format (not as a picture).
Here is a link to a sample dataset. The measures, tables, etc. are titled just as they are above.
https://drive.google.com/file/d/1TDVmGQcTQNk6-3f7XyKgAC33X2u8K87k/view?usp=sharing
