Vision for Comparing Active Directory Groups

[dbatim]

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.

[dbatim]

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

[v-jayw-msft]

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