Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
i'm trying to make a mesure that count the new users and one that count returen users
returen user is is a user that will appear in the records more then one time with a diffrent date
new will be a user with only one apprince in the records
i try this:
example of the data:
date | userid | activityid |
1/6/2021 | 1 | 11 |
1/6/2021 | 1 | 22 |
1/6/2021 | 2 | 55 |
2/6/2021 | 1 | 66 |
it's not working.
it's not take the date in the calculation/ return user will be one that appear in the recorded more then once at a different date
@rco123456 , Try measure
M1 = countrows(FactActivity)
return user = countx(filter(values(FactActivity[UserId]), [M1] >1), [M1])
new user = countx(filter(values(FactActivity[UserId]), [M1] =1), [M1])
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |