LOD calculation

Hi Everyone,

I have a table with 3 columns - Identity, Name, Desc (table and workbook attached)

I created the following calculated fields -

Stage 1 ID { FIXED [Identity]: MIN(if not isnull([Desc]) and [Name]= 'marked'  then [Desc] 

ELSEIF not isnull([Desc]) and [Name] = 'acted_id' and not ISNULL([Name])

then [Desc] end)}

Stage 1 Name - { FIXED [Identity]: MIN(if not isnull([Desc]) and [Name]= 'marked_name'  then [Desc] 

ELSEIF not isnull([Desc]) and [Name] = 'acted_by' and not ISNULL([Name])

then [Desc] end)}

for Identity 53 Stage 1 ID is calculated from "acted_id" however, for Identity 69 it is being calculated from "marked"

for Identity 53 Stage 1 Name is calculated from "acted_by" however, for Identity 69 it is being calculated from "marked_name"

What I wold like to achieve is that if "marked" is null for any Identity, then take value from acted_by and if "marked_name" is null for any Identity, then to take value from "acted_by"

So in the above case the values should come as below

However , I am getting the below result

I tried changing the MAX to a MIN in the LOD calculations stage 1 ID and stage I Name , however I am still getting inconsistent results.

Please advise.

Regards,

Rishi Saka