Need help creating filter/query for Active Directory result in Power BI dashboard

[Anonymous]

1.) If "Owner Type"="Corporate" and "AD Group"="Intune MDM User"...then "AD Group" should display "FLW" ONLY; not "Intune MDM User"

2.) If "Owner Type" = "Corporate" and member of 2 AD Groups = "AD Group" should display "FLW", "Office Worker" or "Exec" and NOT "Intune MDM User" (like the following Measure does now)

Measure =

VAR GroupCount_ =
CALCULATE (
         DISTINCTCOUNT ( 'AD2'[AD Group] ),
         ALLEXCEPT ( 'AD2', 'Table'[Employee Name] )
)
VAR CurrentGroup_ =
        SELECTEDVALUE ( 'AD2'[AD Group] )
RETURN
         IF ( GroupCount_ = 2 && CurrentGroup_ = "Intune MDM User", 0, 1 )

3.) If "Owner Type" = "Personal", then AD Group should display "NONE"

Please help...final "tweak" for my boss.

[Tanushree_Kapse]

@Anonymous This is a calculated column. You can create the column in your table.

[Tanushree_Kapse]

Hi @Anonymous ,

I didn't quite understand your 2nd point. But as per your 1st and 3rd issue:

You can create a seperate calculated column->
AD group(new)= IF(AND(Owner Type= "Corporate", AD Group="Intune MDM User"),"FLW",
                            IF(Owner Type= "Personal","NONE", AD Group))

I hope that helps.

[Anonymous]

Is this a MEASURE ?  Where do I place it ?  How do I create a separated calculated column ?