Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Repeated rows

Hi all,

 

I am trying to get data from 2 different tables using table visualisation. Can I know why my rows is being repeated over and over again? I have some rows that just behave as "headers" to other rows from Excel and other columns empty, I have no idea why the value of one of the column I get from a different file gets repeated over and over again throughout the rows.

 

Need Help

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi Anonymous  - can you please include the headers in the screen grab for a little more clarity.

     

    Also can you confirm that column you do not want to repeat is not of numeric type. Thanks! 

     

    Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous 

       

      The Headers are

      S/NCable NameTypeIDLengthAmpere

       

      The column is a numeric type as I did some formulas and calculations on it. Do I have to change it?

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , based on key on which yow want to check repetition

         

        new column =
        countx(filter(Table, [ID] = earlier([ID]))[ID]) // greater than 1 you are looking for

         

        // ID and S/N

        new column =
        countx(filter(Table, [ID] = earlier([ID]) && [S/N] = earlier([S/N]))[ID]) // greater than 1 you are looking for

         

        New measure =
        countx(filter(Summarize(Table, Table[ID], "_1" count(Table[ID])),[_1]>1),[ID])

        // ID and S/N

        New measure =
        countx(filter(Summarize(Table, Table[ID], Table[S/N], "_1" count(Table[ID])),[_1]>1),[ID])

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous ,

    new column =
    countx(filter(Table, [ID] = earlier([ID]))[ID]) // greater than 1 you are looking for

     

    Put with ID , any ID was displyed is repeating

    New measure =
    countx(filter(Summarize(Table, Table[ID], "_1" count(Table[ID])),[_1]>1),[ID])

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak 

       

      Apologies, so I should add another column to remove the duplicates? Will it affect my other rows?

       

       

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    5 years ago

    Anonymous  Is there an active relationship between these 2 columns or a relationship through a fact table? Can you share the file? 

     

    FYI, when you bring columns from 2 dimensions PBI has to create a CROSSJOIN of two columns, when you drag a measure that removes filters from both the columns then what you get is combination of all the values of both columns 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      AntrikshSharma 

       

      Yes there is. What I am trying to do is pretty complicated and I am trying to solve it one issue at a time.

       

      This is my relationship table ( i am aware of the many-to-many relationship which is not ideal but everything gets messed up when I did it another way)

      • AntrikshSharma's avatar
        AntrikshSharma
        Community Champion
        5 years ago

        Anonymous  It is good that you know this is a bad model, at least I won't be able to provide a solution in case of M:M without interacting with the PBI file. Try to mask the data and share the file.