Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Everyone,
I'm pretty new to power bi and having a hard time with this, I need to create a measure or a way to calculate if a location has been visited by a tech. Each location needs to be visited every month at least once. So if Tech visited in January 2 times it would still just need to be counted once. We want to be able to track this through the year.
Thank you for any help or advice.
Solved! Go to Solution.
@hmast , a new new measure
measure =
var _cnt = calculate(Countrows(Table))
return
sumx(summarize(Table, Table[Month Year], Table[Teacher], "_1", if( _cnt >=1,1,0) ),[_1])
@hmast , a new new measure
measure =
var _cnt = calculate(Countrows(Table))
return
sumx(summarize(Table, Table[Month Year], Table[Teacher], "_1", if( _cnt >=1,1,0) ),[_1])
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 11 | |
| 10 | |
| 8 |