I am trying to measure number of defects across multiple columns, but I only want values greater than 0 to display. I can't currently create a calculated field on a measure value pill, nor can I sort out counts using the filter. My data is set up to measure counts of defect type sorted by columns. For instance, row 1 column 3 in the screenshot (shown as "Ca") lists 8 camber rejects. One important note: there are over 75 different defect columns, so calculating all would be extremely difficult.
I am in need of the following:
Only values greater than 0 to display
When 1 lot has a value > than 0, I need the others to be blank