Struggling to apply sub context (reverse) to existing data table

[Anonymous]

Team,

I'm hoping that I've just been simply staring at this too long today, and this is a quick hit as I'm not looking to get to overly advanced on this.  I have a base table of data that is represented on the left (blue) and a visual I'm after that is on the right (green).  Deal #'s have multiple Service Orders (SO's) associated with them.  A deal is considered ACTIVE until all associated SO's are Closed.  I'm good if all SO's are open, or if all SO's are closed, but it's the in between state that I am unable to overcome.

 I am hung up on the "ACTIVE/INACTIVE" state that needs to be swithed based on if any SO's are still open for a project or not. I truly don't even know where to start right now to build the relationship of the Deal Number to it's SO's, let alone the switching for if the Deal is active or not.  I thank you all in advance for your assistance in pointing me in the right direction to solving this.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Excellent!  This was exactly the bump I was looking to overcome.  Greatly appreciated!!!!

[Ashish_Mathur]

You are welcome.

[v-danhe-msft]

Hi @Anonymous,

From your description, could you please explain the logic about how the "So Status" to affect the "Deal Status", could you please post your desired result if possible?

Regards,

Daniel He