DAX Related not returning all row values, (this should be simple)

[TuqueLogic]

So looking to pull the values from one table to another but many values that should be there are blank.
I'm just using the related function:
newcol = RELATED(table2[ valuesneeded ])

Relationship from table1 to table2 is many to one and active
The key column in the relationship are whole numbers and the rows with missing data have their key values verified to match (via Index/Match in Excel, tables exported from table view in PowerBI)

The values missing from table2 are values from one table that has been appended to table2 in the transform step.

The rows and values are present in table2 the table view in Power BI and the data has been refreshed in Power BI.

Edit: to clarify, I can't see the values in table view. This isn't about visuals or reports.
IE The some row values in table2 are not present in table1 when using RELATED. Even though the key values in the relationship (whole numbers) have been verified in both in Excel (via index/match)

[v-echaithra]

Hi @TuqueLogic ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @TuqueLogic ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra.

[HarishKM · Accepted solution]

@TuqueLogic Hey,
Kindly check below pointer.

Step 1: Check data of both column like confirm both columns in the relationship are exactly (Whole Number, not Decimal or Text). Mismatched types can break relationship.

Step2 : Check for duplicate in column

step 3: try to remove hidden charecter - CLEAN(TRIM(table2[KeyColumn]))

step 4:  Ensure the relationship is active and goes from table1 → table2 (many to one). If it’s the reverse, RELATED() won’t work — you'd need RELATEDTABLE() instead.

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-echaithra]

Hi @TuqueLogic ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra.

[Anonymous]

HI @TuqueLogic,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[TuqueLogic]

Simplified example at bottom.

newcol = RELATED(table2[valuesneeded])

Issue: Not all values are populating in newcol as shown.

keycol values are positive integers (whole number data type in PBI for both columns)
valuesneeded are datetimes ('datetime' used as a placeholder for this example)

table2 is a table that is appended from multiple tables in the Transform step (Power Query)
Transforms are applied and data refreshed in PBI (and updated data can be seen in the rows in of table2)

Tables' relationship is many to one, table1 to table2 and is active

EDIT: in case it is relevant, this is the eq for values needed: 

valuesneeded= MAXX(FILTER (table2, table2[Index] <= EARLIER ( table2[Index] )), table2[CreatedOn] )

CreatedOn is a datetime and Index is an index that is created at in the Transform step (power query) and indexes the keycol. (I realize this is not efficient, looking into recursion in Power Query instead but it's what I have at current.)

table1			table2			table2a
keycol	newcol		keycol	valuesneeded		keycol	valuesneeded
22			1	datetime		1	datetime
33			22	datetime		22	datetime
34	datetime		33	datetime		33	datetime
44	datetime		34	datetime
445	datetime		44	datetime		table2c
448	datetime		445	datetime		34	datetime
554	datetime		448	datetime		44	datetime
664	datetime		554	datetime		445	datetime
6664	datetime		664	datetime		448	datetime
			6664	datetime
			7734	datetime		table2c
			8034	datetime		554	datetime
						664	datetime
						6664	datetime
						7734	datetime
						8034	datetime

[Ashish_Mathur]

Hi,

Your steps seem fine to me.  Share the download link of the PBI file.

[Greg_Deckler]

@TuqueLogic Sample data would assist greatly. You could potentially try using something like:

newcol = 
  VAR __Index = [Index]
  VAR __Result = MAXX( FILTER( 'table2', [Index] = __Index ), [valuesneeded] )
RETURN
  __Result

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.