Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Classified duplicated rows by specific value from another columns

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

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hry Anonymous 

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

     

    Thanks!
    A

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        Hey Anonymous 

        So I did not understnad your requirements.

        Can you explain again?
        Cheers,
        A