Check values of multiple if specific value in other column exists

[Sander_NL]

Hi,

I've the following table:

DTAP	Network
null	Network1
Production	Network1
Acceptance	Network1
Development	Network2
Test	Network2
Development	Network3
Production	Network3
Acceptance	Network3

I need to determine the following:

for which networks the environment production exists than the network is labelled as production. So network 1 and 3 are labelled as production.

Result:

DTAP	Network	Label
null	Network1	Production
Production	Network1	Production
Acceptance	Network1	Production
Development	Network2	Non  production
Test	Network2	Non production
Development	Network3	Production
Production	Network3	Production
Acceptance	Network3	Production

Thanks for your help in advance!

[coskuersanli]

Hi Sander,

You can also use below measure.

Measure =

VAR ASD = CALCULATETABLE('Table','Table'[DTAP] = "Production")

RETURN

IF

(

COUNTROWS(ASD) > 0,

"Production",

"Non-production"

)

[Greg_Deckler · Accepted solution]

@Sander_NL Maybe:

Label Column =
  VAR __Network = [Network]
  VAR __DTAP = SELECTCOLUMNS(FILTER('Table',[Network] = __Network),"DTAP",[DTAP])
RETURN
  IF("Production" IN __DTAP,"Production","Non production")

[Sander_NL]

Thanks Greg! This works perfect!