Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

cagonzalez_0-1621366457977.png

 

 

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.
3 REPLIES 3
Tanushree_Kapse
Impactful Individual
Impactful Individual

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

Tanushree_Kapse
Impactful Individual
Impactful Individual

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
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.