Excluding a row if the columns only displays figures

[rebrow31]

Hi, 

I have a table displaying information on products, how many were good parts, maybe parts and scrap parts. I want to exclude all lines of data from this table where there is only scrap for that product. In the screenshot below for example, the first line I want to be included because there were good and scrap products made. However, the bottom 3 line of data I don't want to appear because these prodcuts wee only scrap. 

I have made a new column within the data using an ID statement, saying if scrap parts = total parts then exclude, otherwise include. however, all this is essentially doing in the data is identidying line by line what is a scrap product, and therefore when I'm filtering by exclude it's just taking all of the scrap parts out of the table. Does anyone know how I can achieve what I need? 

[v-luwang-msft · Accepted solution]

Hi @rebrow31 ,

Try to create a measure like below:

Goodnew = IF(MAX('Table'[Good])=0;BLANK();MAX('Table'[Good]))

Configure like below:

OR create a new vusual like below:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[lbendlin]

Add a (visual or page or report) filter "Good=0"  - that will give you what you need based on your sample data.  If your actual data is different please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.