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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi folks,
I have 2 tables, table 1 'Words' contains a list of Terms in the Term column that are deemed non inclusive:
Table 2 'WorkItems' contains a list of items that may have this term used in the Title column:
I want to count how many times a word from my Term column appears in the Title column - how would I do so?
Solved! Go to Solution.
@Anonymous,
Try this calculated column in Table1:
Term Count =
VAR vTerm = Table1[Term]
VAR vResult =
COUNTROWS ( FILTER ( Table2, CONTAINSSTRING ( Table2[Title], vTerm ) ) )
RETURN
vResult
Proud to be a Super User!
@Anonymous,
Try this calculated column in Table1:
Term Count =
VAR vTerm = Table1[Term]
VAR vResult =
COUNTROWS ( FILTER ( Table2, CONTAINSSTRING ( Table2[Title], vTerm ) ) )
RETURN
vResult
Proud to be a Super User!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.