How to get value for each row in lastnonblank?

[Anonymous]

When I run the following dax code it returns the lastnonblank of whole column from the table. How can I get the result for each row?

(status can be Active or Inactive)

Status = LASTNONBLANK('Production'[Status],1)

I'm writing this measure in tabular which has a fact table(connected to an sql view) and a dimension table. In above dax code 'Production' is a dimension table. 

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.