Classified duplicated rows by specific value from another columns

[Anonymous]

Hi guys, I'm new to powerBI and would require your help to sort out below question which I am facing.

With my dataset, I have a columns as shown below.

My Sheet Number columns have duplicated value based on day. Quality of sheet is classified as BAD or NORMAL for further analysis.

The problems here is I have an duplicated rows of Sheet Number which are showing BAD and NORMAL. I want to create a DAX to indicate the duplicated Sheet Number with BAD qulity to sorted it out. Please Help!!

Best Regards,

PJ

[Anonymous]

Hry @Anonymous 

Did you try using the filters?
Filter out where quality=bad.

Thanks!
A

[Anonymous]

Hi A!

Thanks for the reply @Anonymous  :), but from my dataset as shown. If I filter out BAD quality, I will not get BAD rows which need to be included. 

Thank you

Best regards,

PJ

[Anonymous]

Hey @Anonymous 

So I did not understnad your requirements.

Can you explain again?
Cheers,
A

[Anonymous]

Dear @Anonymous,

My requirement is I want to use DAX to create "Deleted" value of the rows that having an BAD quality which is also having NORMAL quality in the same Sheet number.

Thanks again for your support,

PJ

[Anonymous]

Hi @Anonymous 

Try creating a custom column.

INDICATION =
IF (
    [QUALITY] = "BAD",
    "DELETED",
    "INCLUDE"
)

Good Luck!
A