How to fill a column with a value in another column using ID values as reference

[mhennes1]

Hello!

I am having an issue with a dataset of survey outputs where each question of the survey is a different row of data. There is a column titled "Survey Invitation ID" that identifies each unique survey. I would like to create a column that can take the response to one particular question (always the same question, 5 possible response values) and fill the column with those responses as they correlate to each specific survey ID (i.e. if customer fills out Survey ID 1 and indicates that they work at a university, the new column with results would identify each row from Survey ID 1 as being a university customer). I tried using the formula 

Check = CALCULATE(MAX('August Test Results'[Response Value]), FILTER(ALL('August Test Results'), 'August Test Results'[Question: Name] = "Which of the following best describes your organization?" && 'August Test Results'[Survey Invitation ID] = EARLIER([Survey Invitation ID])))

But I am getting some false results. Attached is a screenshot of what the Survey ID column looks like, as well as the results of the new formula. The second Survey ID with 3 associated rows does not have a response value, but the formula is populating results regardless.

[v-janeyg-msft]

Hi, @mhennes1 

The screenshot you shared shows incomplete information. I can’t see some columns in your code, nor can I see the relationship between Survey Invitation ID and other columns in the table.

But I think you problem is not hard to solve if you can upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[lbendlin]

WARNING!!! Salesforce is case sensitive, DAX is not!!!  You must use Case Safe IDs!!!

(yes, I know, lots of exclamation marks.  But this is important.)