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.