Using last non-zero value in the same column to populate a specific row's value

Sorry if this has come up before but new user and trying to get my head around some of the functions in PowerBI. I have a series of ~ 20 million sample rows for which I am attributing values based on the sample results in the table. I am using the function "Column = LOOKUPVALUE('Result Scores'[Score],'Result Scores'[Code],[Result])" to cross reference the results to the corresponding value. The data looks something like this:

Sample Number          Date    Result  Value

Sample1          1/1/2000          FOU    3

Sample2          1/2/2000          KNA   3

Sample3          1/3/2000          QSB    2

Sample4          1/4/2000          LSD    3

Sample5          1/5/2000          ICN     0

Sample6          1/6/2000          ICN     0

Sample7          1/7/2000          ICN     0

Sample8          1/8/2000          ICN     0

Sample9          1/9/2000          TGS     3

Sample10        1/10/2000        MHG   2

Sample11        1/11/2000        MQV   2

Sample12        1/12/2000        NOE    3

Sample13        1/13/2000        KRW   1

Sample14        1/14/2000        QXV   3

Sample15        1/15/2000        FIB      1

As you can see, result value "ICN" pulls a 0 value. There are multiple such results that could pull a 0 instead of value 1-3, and they can be sequential as they appear in the above. Since the ICN results follow result LSD, I want each of the ICN results to carry over the value 3, not 0. This would be true whether it was a 1, 2 or 3. The results with a 0 value should carry the value of the previous sample indefinitely until a sample with a non-zero value comes up. I know I can use IF with LOOKUPVALUE to reference a previous row's result, but I am not sure how to continuously use that result until a non-zero value is returned.