Forum Discussion

dbatim's avatar
dbatim
New Member
4 years ago

Vision for Comparing Active Directory Groups

Before I even try to create something. I'd like to see if someone has something similar. My PowerBI skills are limited so forgive me.

I would like TWO dropdown slicers. These slicers are populated using a backend database that shows users and active directory groups. Based on the two slicer selections I would like a list of people that are in one of the AD groups but not the other, or an option to return only those that match. So I can compare users say in the HR department AD group verus users in the GYM Ad group to see users that match, and users that do not.

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi dbatim ,

     

    You will need to create two independent slicer tables, then create a measure like below:

    Measure = 
var list1 = CALCULATETABLE(VALUES('Table'[user]),FILTER('Table','Table'[AD] = SELECTEDVALUE(slicer1[AD])))
var list2 = CALCULATETABLE(VALUES('Table'[user]),FILTER('Table','Table'[AD] = SELECTEDVALUE(slicer2[AD])))
return
IF(SELECTEDVALUE('Table'[user]) in list1&&SELECTEDVALUE('Table'[user]) in list2,1,0)

     

    Best Regards,

    Jay

  • dbatim's avatar
    dbatim
    New Member
    4 years ago

    Sorry for the delay. Thank you for the response. I will try and "drum" something up for a quick test and let you know.