Forum Discussion

emma313823's avatar
emma313823
Helper V
9 years ago
Solved

Relationships Issue

Hi All   I have an issue which I can't seem to figure out what is causing it.   I have pulled in two tables of customer related data of which a common relationship is the part number.  I pulled o...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Oops, change COUNTROWS to COUNT.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Drop your NBO PNs Claimed[Parts Number] column onto a table visual, then add this measure:

 

Duplicate Test = COUNTROWS(NBO PNs Claimed[Parts Number])

 

Sort the table visual in descending numeric order by that measure and you will find something with a result of at least 2.

  • emma313823's avatar
    emma313823
    Helper V
    9 years ago

    Hi - trying to use your suggestions, however it shows the following...any thoughts?  Can't sseem to get it to work

     

    • emma313823's avatar
      emma313823
      Helper V
      9 years ago

      sorry one more thing...I had to fix what you showed as PARTS NUMBER to Part Number - there was no 's' in part.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Delete the part that says "Measure = "