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.

emma313823's avatar
emma313823
Helper V
9 years ago

so sorry for all the questions...I removed measure = and it now shows this...

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Oops, change COUNTROWS to COUNT.

  • emma313823's avatar
    emma313823
    Helper V
    9 years ago

    Perfect....thanks so much for your help.  Great trick for my toolbox!

     

    Emma

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Glad I could help. How many duplicates did you find? :smileyhappy:

      • emma313823's avatar
        emma313823
        Helper V
        9 years ago

        there were 4.  I'm curious...not sure if you know or not, but if I use the query editor to remove duplicates prior to pulling the data in, why are duplicates still showing?