Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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])