write dax for the following query

[pasupathi]

Dear Helper

i have 2 columns 

ProjectStatus                   DeveloperName            

DEV                                      A

Developer allocated             B

FSD                                       C

Hold                                     D

Hypercare                             E

Live                                       F

UAT                                      G

question: if any developer name is not under DEV,FSD,UAT show developer name. write DAX  

Regards

pasupathi

[v-rzhou-msft · Accepted solution]

Hi @pasupathi ,

I think you just need to create a measure to get the developernames which are not under DEV,FSD,UAT.

Measure:

DeveloperName not in {DEV,FSD,UAT} = 
CALCULATE (
    MAX ( 'Table'[DeveloperName] ),
    FILTER ( 'Table', NOT ( 'Table'[ProjectStatus] IN { "DEV", "FSD", "UAT" } ) )
)

Result is as below.

I have attached my sample file as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rohit_singh]

Hi @pasupathi ,

Please create a calculated column on your table like below :

Dev Name =

var _list = {"DEV","FSD", "UAT"}

var _dev =

CALCULATE(

MIN(Project[DeveloperName]),

FILTER(allexcept(Project, Project[ProjectStatus]), NOT(Project[ProjectStatus]) IN _list

)

)

RETURN
_dev

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Syndicate_Admin]

Dear helper

can you share powerbi file