Measure doubt

Hello Team ,
Following is my raw data table 

So i have to create a measure which will help me show visualization in powerbi report 

I have to check if the current document which has the largest revision ID and which is latest column is True , should be either work in progress or should be released 

but if there is a document of which revision is not the largest and it is not the latest then it should be released first and then the higher revision id document work should be started .

for example the last two rows can be seen that the revision id 43 is still work in progress and it is not even latest but still not released hence we should make a measure which will show in next column using measure as shown below,

that means the latest largest revision must be only in work in progress if the earlier row is released . if the earlier row is not released it is still work in progress then measure should flag them as shown above 

please ask questions if anything is not clear any help is appreciated 

please help