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
91asma2
Helper I
Helper I

count of distinct two columns in one table

Hi all, 
I am trying to calculation the unique number of users who did 2 or more activities from two separate columns in one table. 
My data looks like this: 

 

Table  

 

user_idactivity_id
1aa
2aa2
3aa3
4aa4
5aa5


First I want to get the distinct count of users and then filter those users that have done 2 or more activities.
I am trying something like this, but I am not getting the values right. 

VAR allData =
ADDCOLUMNS(
VALUES(Table[activity_id]),
"rowCount",
CALCULATE( COUNTROWS( Table) )
)
return
CALCULATE(
COUNTROWS( allData ),
filter (allData, [rowCount] >=7)
)

 

 

I appreciate all the help. 

2 REPLIES 2
amitchandak
Super User
Super User

@91asma2 , Try a measure like

 

countx(filter(summarize(Table, Table[user_id], "_1", count(Table[activity_id])),[_1]>=2),[user_id])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks a lot @amitchandak !
Can you explain to me this forumla, more walk me thought it? 


I am trying to validate the values. and I am trying to change the filter from 2 to 1 to 3 ...etc but the number doesnt change. 

so I am not sure its counting the right values. 


What I am trying to get the count of users who has 2 or more activities. 

 

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.