Forum Discussion
Duplicate rows when bringing data from multiple tables
HI ImprintGroup ,
Based on your current description, it is caused by the fact that you have a 1-to-many relationship between your table and the table before it. Just like in database, using left join to query two tables, if the fields in table 1 have more than one corresponding value in table 2, this will happen. Your current view is that there should be multiple correspondences between table 3 and other tables.
Also, according to your description, you only want to display one data in table 3, you can generate a new table based on table 3, and then create a relationship with the new table.Sample:
tableA:
tableB:
relationship:
Output:
Step1,cancel relationship:
Step 2, add index on the tableB:
Step 3, base on table B ,create new tableC:
rank1 = RANKX(FILTER(TableB,TableB[index]=EARLIER(TableB[index])),TableB[Index.1],,ASC,Dense)Step4 ,create relationship ,and new visual:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
ImprintGroup You can turn stepped layout off under options, then need to play with formatting:
As for your repeated values, do you want it blank?
Try using ISINSCOPE in a measure:
New Value = IF ( ISINSCOPE( table[event], BLANK(), SUM(table[value]) )
AllisonKennedy This has me closer. But I can only see 8 out of about 16 "columns". I'm unable to scroll horizontally.
I would prefer the repeated values be blank and I'll see what I can accomplish with your suggestion on the measure.