DAX for finding the status based on multiple criteria

[AS123]

I have a dataset where I need to set the status of a user as Active or Inactive based on multiple criterias:

For any customer if there is any active user the status of Admin user should always be active irrespective of the status of that particular user. How can I do that in power BI?

[Fowmy · Accepted solution]

@AS123 

Add the following calculated column to your table:

New Status = 

VAR __Flag = 
    CALCULATE( 
        COUNTROWS( Table01),
        Table01[Status] = "Active",
        ALLEXCEPT( Table01 , Table01[Customer] )
    )
VAR __Result = 
    IF(
        Table01[Admin] = "Yes"  && __Flag > 0 , 
        "Active",
       Table01[Status]
    )
RETURN
    __Result

[CoreyP]

You can write the logic by using conditional DAX statements like IF or SWITCH/TRUE.