Distinct count of users who clicked x and y (example data included!)

[DanNewton]

Hi all, I have a requirement to create a count of distinct users who clicked both x and y using website analytic data. After some researching I am struggling to understand how to do this and would welcome any suggestions/help.

I have included a screenshot of sample data as the forum software kept removing the HTML table:

From the table above the resulting measure shoud show a count of 2, i.e. 2 distinct users clicked BOTH X and Y.

[ryan_mayu · Accepted solution]

@DanNewton 

Pls try this

MEASURE = 
var tbl=SUMMARIZE(FILTER('Table','Table'[Clicked]="X" || 'Table'[Clicked]="Y"),'Table'[USER_ID],"COUNT",DISTINCTCOUNT('Table'[Clicked]))
RETURN COUNTROWS(FILTER(tbl,[COUNT]=2))

[amitchandak]

@DanNewton , Try a measure like this with user ID

countx(filter(summarize(Table, Table[User], "_1", calculate(distinctcount(Table[Clicked]), filter(Table, Table[Clicked] in {"X", "Y"}))),[_1] =2),[User])