Calculate amount of users subscribed to more than 1 competition

[Anonymous]

I'm trying to figure out the distinct number of users that have entered a team in more than 1 competition. Users can have multiple teams per competition, the amount of teams is not relevant.

Every team entry is a line where paid = 1 indicates they have paid for a team.

So what I would like to calculate is: distinctcount of users who have paid for 1(or more) teams in 2 or more competitions.

This is a sample:

competition_feed	user_id	paid
Comp_2	42647	1
Comp_2	24870	0
Comp_2	8949	1
Comp_6	16732	1
Comp_1	7411	1
Comp_7	29130	0
Comp_2	46753	0
Comp_2	6497	1
Comp_3	29816	1

Any help would be greatly appreciated as I can't seem to figure this out.

[amitchandak · Accepted solution]

@Anonymous , Create a measure like this and try

countx(filter(summarize(filter(Table, Table[paid] =1), Table[USer_id], "_1", calculate(distinctCOUNT(Table[competition_feed]))),[_1] >1),[USer_id])

[Anonymous]

Brilliant, thanks a lot !

If you were to create a matrix overview per competition of the amount of users with teams in multiple competitions, would this also be possible?

For instance: comp_1 has 100 users subscribed to multiple competitions, comp_2 88 users, ...

[Anonymous]

Brilliant, thanks a lot !

If you were to create a matrix overview per competition of the amount of users with teams in multiple competitions, would this also be possible?

For instance: comp_1 has 100 users subscribed to multiple competitions, comp_ 88, ...