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 this is the difference between using the 'matrix' visual in Power BI and the 'table' visual. Use a 'matrix' visual and you will get blanks for repeated program.
I'm trying to use the Matrix visual now. While I struggle with not being able to visually represent each data point across the row in columns, as I add the financials I still end up with repeating amounts for each line where there is an event.
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.